/SQL/How to drop all tables in postgresql

How to drop all tables in postgresql

How to remove tables from postgresql

DROP TABLE IF EXISTS tablename;

Force drop all tables postgres

DROP SCHEMA public CASCADE;
CREATE SCHEMA public;

How to drop all tables in postgresql

DROP SCHEMA public CASCADE;
CREATE SCHEMA public;GRANT ALL ON SCHEMA public TO postgres;GRANT ALL ON SCHEMA public TO public;

Source: makandracards.com

Postgres drop all tables

DO $$ 
  DECLARE 
    r RECORD;
BEGIN
  FOR r IN 
    (
      SELECT table_name 
      FROM information_schema.tables 
      WHERE table_schema=current_schema()
    ) 
  LOOP
     EXECUTE 'DROP TABLE IF EXISTS ' || quote_ident(r.table_name) || ' CASCADE';
  END LOOP;
END $$ ;

Source: kags.me.ke

Similar codes

4 votes141 views2 answers
Postgresql reset sequence
SQL
3 votes212 views3 answers
Restart mysql mac
SQL
0 vote179 views2 answers
Plpgsql
SQL
0 vote209 views1 answer
Mariadb used space
SQL
10 votes168 views2 answers
What is database
SQL
1 vote166 views3 answers
How to truncate table with foreign key constraint
SQL
0 vote157 views1 answer
List all indexes postgres
SQL
0 vote184 views10 answers
John the ripper mysql
SQL
10 votes120 views2 answers
Mysql select timestamp group by day
SQL
0 vote145 views3 answers
Average salary in sql
SQL