Sep 03 2008

Delete All Data In A PostgreSQL Table Using PGAdmin

Posted by alex in Insights at 5:18 PM

Open PGAdmin and connect to the database where you would like to remove all data from a certain table. Click the SQL (execute arbitrary SQL commands) button. Use the below syntax and all data will be removed.

truncate table table_name


Using truncate is much quicker than delete since it does not scan the table you are deleting.

Related posts:

  1. How To See The Number Of Rows In A PostgreSQL Table Checking the number of rows in a PostgreSQL table is...
  2. How To Upgrade PGAdmin on Windows There is not an auto upgarde button built into pgadmin...
  3. Settings for Creating a New Database in PostgreSQL I wanted to quickly create a new database via pgAdmin...
  4. Making (and Verifying) the Migration to PostgreSQL in Rails Install After installing PostgreSQL on Windows, I converted my Rails...
  5. Timestamp support for Rails and MySQL/PostgreSQL/Oracle Troel has written a great summary of the SQL standard...
Tags: , , , , , ,

This entry was posted on Wednesday, September 3rd, 2008 at 5:18 PM and is filed under Insights. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.

« 
 »
Leave a Reply

*Type the letter/number combination in the abvoe field before clicking submit.

CAPTCHA Image
*