Articles related to technology, how to use software, ways to work around technology problems, install hardware, install software, upgraded software, etc.

Technology Insights

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. Connect: Connect to PostgreSQL with psql. Delete Rows: Type the following from the CLI. bash dev=# truncate table <em>table_name</em>…