Introducing PopSQL + dbt. The first SQL editor with built-in dbt support.Read more →

How to Truncate a Table in PostgreSQL

Be very careful with this command. It will empty the contents of your PostgreSQL table. This is useful in development, but you'll rarely want to do this in production.

truncate my_table

If you have a serial ID column and you'd like to restart its sequence (ie restart IDs from 1):

truncate my_table restart identity

Ready for a modern SQL editor?