/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

0 vote309 views1 answer
Delete ids between sql
SQL
17 votes256 views4 answers
Postgres list users
SQL
2 votes247 views3 answers
Sql function
SQL
0 vote248 views1 answer
Sql show table name in result
SQL
7 votes240 views1 answer
Xampp reset mysql
SQL
0 vote243 views1 answer
Sql get year from datetime field
SQL
4 votes242 views1 answer
Mysql not equal
SQL
1 vote233 views2 answers
Rebuild index sql server
SQL
0 vote226 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
0 vote229 views1 answer
Sql last 7 days
SQL