PostgreSQL empties data table data

In MySQL, you only need to perform:

TRUNCATE table_name;

, the data will be the case, and the self-increment ID will be changed back to 0;

But the PostgreSQL is slightly different, because the self-increment ID of PostgreSQL is done by sequence sequence,

So after the situation data, you also need to restore the sequence sequence:

TRUNCATE IDENTITY;

Official Document: Https://www.postgresql.org/docs/9.2/static/sql-truncate.html

Another way: (Because of different versions, may command different)

truncate Table table_name; Alter 1;

Reference: Https://stackoverflow.com/questions/13989243/sequence-does-not-reset-after-truncating-the-table

PostgreSQL empties data table data