Answers for "clear all tables postgresql"

SQL
0

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
0

postgres clear table

TRUNCATE [ TABLE ] [ ONLY ] name [ * ] [, ... ]
    [ RESTART IDENTITY | CONTINUE IDENTITY ] [ CASCADE | RESTRICT ]
Posted by: Guest on October-20-2020

Code answers related to "clear all tables postgresql"

Code answers related to "SQL"

Browse Popular Code Answers by Language