PostgreSQL Delete

PostgreSQL Delete

The PostgreSQL DELETE statement is used to delete records from a table.

Delete syntax

--deletes the records that meet the conditions
DELETE FROM table_name WHERE {conditions}

-- delete all records from table
DELETE FROM table_name

Delete example

DELETE FROM goods WHERE id=2;

DELETE FROM goods WHERE name like '%Car%';

DELETE FROM goods;