Postgres drop all tables

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

0 vote213 views1 answer
Excute raw query
SQL
7 votes216 views2 answers
Oracle foreign key reference table
SQL
0 vote216 views1 answer
Sql date d'aujourd'hui
SQL
1 vote236 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL
0 vote210 views1 answer
Postgresql extract hour and minutes from timestamp
SQL
1 vote220 views1 answer
Oracle compile schema
SQL
2 votes202 views1 answer
Mysql auto increment jumping
SQL
1 vote239 views3 answers
How to pass password to mysql command line
SQL
0 vote215 views1 answer
Mssql check if date is greater than today
SQL
0 vote264 views1 answer
Sql query to select even numbers
SQL