Tech Insights· postgresql.org
Use TRUNCATE with RESTART IDENTITY to restart sequences as well:
From postgresql.org
TRUNCATE TRUNCATE — empty a table or set of tables Synopsis TRUNCATE [ TABLE ] [ ONLY ] name [ …
Shared by
- Postgresql
- SQL



