delete from postgres table code example

Example 1: how to remove tables from postgresql

DROP TABLE IF EXISTS tablename;

Example 2: postgres delete database

CREATE DATABASE testdb1;
DROP DATABASE testdb1;

Example 3: delete entries in postgresql

DELETE FROM table WHERE condition;

Example 4: delete entries in postgresql

DELETE FROM table
USING another_table
WHERE table.id = another_table.id;