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)

 

APPIP ERROR: amazonproducts[
AccessDeniedAwsUsers|The Access Key Id 1ZNGM52M8EWAXJFFRR82 is not enabled for accessing this version of Product Advertising API. Please migrate your credentials as referred here https://webservices.amazon.com/paapi5/documentation/migrating-your-product-advertising-api-account-from-your-aws-account.html.
]