truncate ... cascade postgresql example

Example 1: postgresql truncate cascade restart identity

TRUNCATE bigtable, fattable RESTART IDENTITY;

Example 2: postgres clear table

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