postgres delete rows on condition code example
Example 1: delete all entries postgres
DELETE FROM tablename;
Example 2: delete entries in postgresql
DELETE FROM table
USING another_table
WHERE table.id = another_table.id;
DELETE FROM tablename;
DELETE FROM table
USING another_table
WHERE table.id = another_table.id;