psql truncate table code example

Example 1: postgresql truncate cascade restart identity

TRUNCATE bigtable, fattable RESTART IDENTITY;

Example 2: truncate table postgres

TRUNCATE TABLE table_name;

Example 3: truncate table postgres

truncate my_table restart identity