Answers for "truncate table in postgresql"

SQL
0

restart identity cascade

TRUNCATE <table_name> RESTART IDENTITY CASCADE;
--RESTART will reset the identity sequence
--CASCADE all tables that have a foreign key reference to 
--table_name will be truncated as well
Posted by: Guest on July-14-2020
0

truncate table postgres

truncate my_table restart identity
Posted by: Guest on May-10-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 "SQL"

Browse Popular Code Answers by Language