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

0 vote315 views1 answer
Mysqlcli how to load external sql file
SQL
0 vote342 views1 answer
Dataframe lambda elif
SQL
2 votes312 views1 answer
Power query concatenate
SQL
0 vote286 views1 answer
Mariadb LOAD DATA INFILE
SQL
0 vote298 views1 answer
Laravel general error 2006 mysql server has gone away
SQL
0 vote320 views1 answer
View to table sql
SQL
2 votes501 views5 answers
Unique in sql server
SQL
0 vote327 views1 answer
Mysql db dump restore max file size issue
SQL
0 vote290 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
0 vote315 views1 answer
How to add unique key constraint in mysql
SQL