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.

Tags: , , , , , ,
Leave a Reply

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