Deleting Data

What is Deleting Data in PostgreSQL?

Deleting data from Postgres database table means removing entire rows or row from that table.

Removing All Rows from a Given Table

To delete all rows from a given table use the DELETE command appended with the table name and without providing any conditions regarding the rows to delete.

DELETE FROM users;

The above command removes all rows from the table users.

Removing Only Specific Rows from a Given Table

It is possible to delete only rows meeting specific criteria. The criteria (conditions) are provided using the key word WHERE appended with a boolean expression which can reference cell values of the table rows.

DELETE FROM products
WHERE fit_for_consumption = FALSE;

The above command removes only those rows from products which have the column fit_for_consumption value set to FALSE.