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

1 vote171 views1 answer
Postgres set column equal to another
SQL
0 vote159 views1 answer
Check if a word appears at the end sql query
SQL
3 votes174 views1 answer
Query less than datetime sql
SQL
1 vote162 views3 answers
Rename table snowflake
SQL
0 vote173 views1 answer
Postgres type equivalent to timespan c#
SQL
0 vote175 views1 answer
Postgres full text search example
SQL
4 votes160 views3 answers
Order by value mysql
SQL
2 votes165 views1 answer
Pandas to sql index
SQL
2 votes165 views1 answer
Docker run postgres locally
SQL
6 votes190 views2 answers
Oracle trigger
SQL