Топ-100
 

TRUNCATE

RDBMS Type: PostgreSQL
Topic

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

Example

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