/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

45 votes398 views5 answers
Grant all privileges mysql
SQL
0 vote327 views1 answer
Alasql delete column
SQL
1 vote312 views2 answers
DROP TABLes regardless of constraints
SQL
0 vote344 views1 answer
Oracle cpu metric
SQL
0 vote336 views1 answer
Sql shell psql cannot enter password
SQL
0 vote350 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
3 votes304 views1 answer
Insert into table from another table mysql
SQL
1 vote334 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
0 vote320 views1 answer
Exclude last comma separated string mysql
SQL
3 votes353 views2 answers
Mysql update row
SQL