/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

2 votes217 views1 answer
Sql get the name of user pc
SQL
15 votes185 views2 answers
Open postgress in terminal mac
SQL
5 votes217 views1 answer
Pl sql asynchronous procedure calls
SQL
2 votes185 views1 answer
Sql as
SQL
11 votes185 views1 answer
Get ddl materialized view oracle
SQL
0 vote185 views1 answer
Create a PostgreSQL user django on mac
SQL
1 vote177 views1 answer
Mysql check string don't have number
SQL
0 vote238 views1 answer
Sql query to find percentage of null values in a table
SQL
0 vote178 views1 answer
Postgresql parse json array
SQL
0 vote147 views2 answers
Postgresql could not start server mac
SQL