top of page
CerebroSQL

PostgreSQL:  

TRUNCATE

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

Example

TRUNCATE bigtable, fattable;
TRUNCATE bigtable, fattable RESTART IDENTITY;
TRUNCATE othertable CASCADE;

bottom of page