/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

1 vote146 views1 answer
Sql set auto increment back to 0
SQL
1 vote149 views1 answer
Oracle apex version view
SQL
0 vote118 views1 answer
Myswql show full processlist
SQL
0 vote130 views1 answer
Manage Database in MySQL
SQL
1 vote149 views1 answer
Oracle grant select on schema
SQL
0 vote125 views1 answer
Denormalise SQL command
SQL
1 vote128 views1 answer
Mysql date diff in seconds
SQL
13 votes117 views6 answers
Current date sql
SQL
6 votes141 views2 answers
Postgresql pg_dump
SQL
4 votes124 views1 answer
Update table from another table oracle
SQL