Answers for "how to delete tables in postgresql"

how to remove tables from postgresql

DROP TABLE IF EXISTS tablename;

Posted by: Guest on August-27-2020

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;

Posted by: Guest on August-03-2021

postgres clear table

TRUNCATE [ TABLE ] [ ONLY ] name [ * ] [, ... ]
    [ RESTART IDENTITY | CONTINUE IDENTITY ] [ CASCADE | RESTRICT ]

Posted by: Guest on October-20-2020

Code answers related to "how to delete tables in postgresql"