/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 vote150 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
0 vote128 views1 answer
Sql change date format
SQL
0 vote128 views1 answer
Gcloud check sql
SQL
0 vote135 views1 answer
Open postgresql.conf in centos
SQL
0 vote123 views1 answer
Opensuse status MySQL
SQL
0 vote145 views1 answer
Mysql remove bad character from all fields
SQL
3 votes124 views2 answers
Oracle sql truncate table
SQL
0 vote116 views1 answer
Oracle sql count occurrences of value in column
SQL
0 vote150 views3 answers
Call to undefined function mysql_connect()
SQL
0 vote128 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL