PostgreSQL - DELETE

In PostgreSQL, DELETE statement is used to delete the existing records from a table. You can use WHERE clause with DELETE statement to delete the selected rows. Otherwise, all the records would be deleted.

Syntax

Following is the basic syntax of DELETE Statement with WHERE clause is as follows −

DELETE FROM table_name
WHERE [condition];

You can combine N number of conditions using AND or OR operators.

Example of DELETE Statement

While delete something to the table, we first create a table to show the records and then use the delete statement with "WHERE" clause to delete the specfic rows or all rows.

Consider the table COMPANY, having records as follows −

select * from COMPANY;

Here, we write the query to DELETE a customer whose ID is 7 −

testdb=# DELETE FROM COMPANY WHERE ID = 2;

Now, COMPANY table will have the following records −

Delete All Records

If you want to DELETE all the records from COMPANY table, you do not need to use WHERE clause with DELETE queries, which would be as follows −

testdb=# DELETE FROM COMPANY;

Now, COMPANY table does not have any record because all the records have been deleted by the DELETE statement.