Delete rows of a table

DELETE — delete rows of a table
[ WITH [ RECURSIVE ] with_query [, ...] ]
DELETE FROM [ ONLY ] table_name [ * ] [ [ AS ] alias ]
   [ USING from_item [, ...] ]
   [ WHERE condition | WHERE CURRENT OF cursor_name ]
   [ RETURNING * | output_expression [ [ AS ] output_name ] [, ...] ]

Table, foreign table, external table, show table, Delete rows of a table, Table Partitioning, \dt