DELETE statement

Definition

The DELETE statement allows you to delete rows of a table.

SQL Syntax

Syntax:

[ WITH [ RECURSIVE ] with_query [, ...] ]
DELETE FROM [ ONLY ] table_name [ [ AS ] alias ]
    [ USING from_item [, ...] ]
    [ WHERE condition ]
    [ RETURNING * | output_expression [ [ AS ] output_name ] [, ...] ]

To fully study the SQL Select clause, visit its documentation https://www.postgresql.org/docs/current/sql-delete.html