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

4 votes206 views2 answers
Oracle unliock account
SQL
0 vote201 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
0 vote185 views1 answer
Postgresql log
SQL
3 votes170 views1 answer
Sql server version query
SQL
0 vote198 views3 answers
Join
SQL
5 votes214 views1 answer
How to check port number for postgresql
SQL
1 vote187 views1 answer
Sql current timestamp
SQL
1 vote173 views3 answers
How to get date in sql
SQL
0 vote181 views1 answer
Mysql query with sql to get the next row
SQL
3 votes178 views1 answer
Oracle apex call duration
SQL