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

2 votes308 views1 answer
Plsql left() function
SQL
13 votes318 views4 answers
Mysql select last 10 rows
SQL
0 vote316 views1 answer
How to find unique key in sql
SQL
1 vote362 views3 answers
How to pass password to mysql command line
SQL
1 vote333 views2 answers
Oracle 18c xe ORA-65096
SQL
0 vote341 views1 answer
Connect laravel to mysql on mac
SQL
1 vote348 views1 answer
Code: "ER_TRUNCATED_WRONG_VALUE", errno: 1292, sqlMessage: "Incorrect date value: '2021-03-20T18:30:00.000Z' for column 'mgfdate' at row 1", sqlState: "22007", index: 0, …}
SQL
0 vote330 views1 answer
How to execute stored output to csv files
SQL
1 vote342 views2 answers
Drop function in sql
SQL
-1 vote336 views5 answers
Online sql to linq generator
SQL