[PostgreSQL] DELETE

DELETE

-- deleting all table rows
DELETE FROM stock_backup;

-- deleting rows
DELETE FROM stock WHERE stock=0;

 

-- deleting optional rows

DELETE FROM stock WHERE stock='1234' and std_code='MAN200001';