/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

14 votes376 views3 answers
Delete all records from table except sql
SQL
0 vote316 views1 answer
SQL server select to get sum of hours
SQL
0 vote345 views2 answers
Null value in column violates not-null constraint
SQL
0 vote349 views1 answer
Start and stop mysql
SQL
0 vote372 views1 answer
Pgsql is not permitted to log in
SQL
33 votes362 views6 answers
Change column name in mysql
SQL
3 votes352 views3 answers
Mysql order by list
SQL
1 vote336 views1 answer
Display total number of tables in mysql
SQL
0 vote362 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL
1 vote360 views1 answer
ORACLE RIGHT TWO DIGITS
SQL