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)