postgresql delete table code example

Example 1: how to remove tables from postgresql

DROP TABLE IF EXISTS tablename;

Example 2: postgresql drop table

DROP TABLE name;

Example 3: postegresql delete

DELETE FROM films
  WHERE producer_id IN (SELECT id FROM producers WHERE name = 'foo');

Example 4: postgres clear table

TRUNCATE [ TABLE ] [ ONLY ] name [ * ] [, ... ]
    [ RESTART IDENTITY | CONTINUE IDENTITY ] [ CASCADE | RESTRICT ]

Example 5: psql delete table

DROP TABLE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]