/SQL/Postgresql truncate cascade restart identity

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 vote127 views1 answer
Match end of string regex sql
SQL
0 vote111 views1 answer
Knex last insert id mysql
SQL
0 vote132 views1 answer
Oracle string substitution
SQL
3 votes143 views2 answers
Mysql select database
SQL
-2 votes131 views1 answer
Mysql see users and passwords
SQL
2 votes131 views1 answer
Mysql application.properties spring boot
SQL
0 vote123 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
3 votes135 views1 answer
Oracle revoke
SQL
0 vote122 views6 answers
Unique key in sql
SQL
38 votes186 views4 answers
Count sql
SQL