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.
If you have a serial ID column and you'd like to restart its sequence (ie restart IDs from
truncate my_table restart identity