/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

3 votes114 views1 answer
Unsigned int in mysql
SQL
-1 vote106 views3 answers
Error mysql shutdown unexpectedly
SQL
0 vote104 views1 answer
Mysql docker image for macbook m1
SQL
0 vote104 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
0 vote116 views1 answer
Mysql get date diff in months
SQL
2 votes101 views1 answer
Sql ignore accents
SQL
0 vote107 views1 answer
Mysql count with two joins
SQL
0 vote116 views1 answer
Intellij idea add mysql connector
SQL
0 vote108 views1 answer
Sql list dates between two dates
SQL
0 vote131 views1 answer
Where to find pg_hba.conf in ubuntu
SQL