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 votes346 views1 answer
Oracle table statistics
SQL
1 vote268 views1 answer
User privileges postgresql information_schema
SQL
1 vote274 views1 answer
Postgres start database on linux
SQL
5 votes253 views1 answer
Mysql select greater than yesterday
SQL
0 vote283 views1 answer
How to Remove milliseconds from Date time
SQL
0 vote264 views1 answer
Mysql create table like
SQL
1 vote287 views1 answer
Postgresql export output table as a csv
SQL
0 vote259 views7 answers
10 random questions use python and SQL
SQL
0 vote267 views1 answer
Find wordpress version in database
SQL
1 vote260 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL