Restart identity cascade

Postgresql truncate cascade restart identity

TRUNCATE bigtable, fattable RESTART IDENTITY;

Source: postgresql.org

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

Similar codes

44 votes185 views6 answers
Rename command in sql
SQL
0 vote110 views1 answer
Vbscript clean up ADODB.Recordset
SQL
0 vote107 views1 answer
Sql server change schema of a table
SQL
0 vote107 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
7 votes117 views2 answers
Oracle sql drop index
SQL
11 votes120 views2 answers
How to import mysql database command line
SQL
0 vote121 views1 answer
SQLServerException.makeFromDatabaseError
SQL
1 vote138 views1 answer
Drop colum oracle 18c
SQL
0 vote106 views1 answer
Mysql database hyphen
SQL
0 vote100 views1 answer
Sql select most frequent value in group
SQL