/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 vote210 views1 answer
Createdb with postgresql on ubuntu
SQL
0 vote193 views1 answer
Calculate age in sql
SQL
0 vote237 views1 answer
Postgresql alter table sequence
SQL
57 votes2.2K views5 answers
How to create a new user in postgresql
SQL
0 vote190 views1 answer
Reading from right to left from string find first special characters in sql
SQL
0 vote208 views2 answers
How to login to mysql as normal user in ubuntu
SQL
7 votes212 views2 answers
Where keyword sql
SQL
0 vote182 views2 answers
Drop check constraint in ms sql
SQL
0 vote210 views1 answer
No suitable driver found for sqlite
SQL
1 vote196 views1 answer
Install postgresql on raspberry pi
SQL