[PostgreSQL] Truncate Table and Reset Sequence

If we need that after TRUNCATE table, also reset the SEQUENCE then we can do this step :

1. Set the minimum value of the sequence

alter sequence mytable_id_seq minvalue 0 start with 1;

2. Now either reset it:

SELECT setval('mytable_id_seq', 0)

OR we can reset it while truncating:

truncate mytable restart identity;

Artikel Terkait :

• [Oracle EBS] Purge Concurrent Request and/or Manager Data
• [Oracle EBS] Query to list Reports assigned to a Responsibility
• [Oracle EBS] Query to list Active Responsibilities assigned to Active User
• [Oracle EBS] ORA-01591 In-Doubt Transactions
• [Oracle EBS] Query to list Reports assigned to a Responsibility
• [Oracle EBS] Query Period Status
• [Oracle EBS] Query To Find Application Name And Short Name
• [PostgreSQL] Truncate Table and Reset Sequence
• [Oracle Siebel CRM] Query Last User Active