Delete All Rows from a PostgreSQL Table

Use the truncate command from the CLI or via PGAdmin to delete all rows from a PostgreSQL database. To use PGAdmin follow the directions here or follow the directions below to truncate the table from the CLI.

1. Connect: Connect to PostgreSQL with psql.
2. Delete Rows: Type the following from the CLI.
bash


1. dev=# truncate table <em>table_name</em>
3. Verify Data: Verify all the data has been deleted by using the following command.
bash


1. dev=# select count(*) from <em>table_name</em>;
2. count
3. -------
4. 0
5. (1 row)

 

See larger image SQL in a Nutshell: A Desktop Quick Reference Guide (In a Nutshell (O’Reilly)) (Paperback) List Price: $44.99 USD New From: $23.43 USD In Stock Used from: Too low to display In Stock