clear table psql code example

Example 1: delete entries in postgresql

DELETE FROM table WHERE condition;

Example 2: delete all entries postgres

DELETE FROM tablename;

Example 3: postgres clear table

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