How to delete all data from table of PostgreSQL in pgAdminIII

There are two ways to delete or remove all data from table without deleting the table itself.

Method 1

Step 1: Select database and table that you want to remove the data from.

Step 2:  Then right click on that table and choose "Truncate"

Step 3: After it will ask you whether you want to remove data from table or not. Just click Yes to confirm.

Method 2

Another way, we also can use query tool to delete data from table in PostgreSQL database.
 

Step 1: Go to Tools on top bar of pgAdmin III  Query tool

Step 2: Use query “Truncate name of table that you want to remove data;” and click Execute query button

Now you are successful in removing data from table in PostgreSQL. Cheer!