DELETE

AttentionThis page documents an earlier version. Go to the latest (v2.1)version.

Synopsis

The DELETE statement removes rows from a specified table that meet a given condition. Deleting multiple rows is not yet supported.

Syntax

Diagram

DELETE - 图1

Grammar

  1. delete ::= DELETE FROM table_name WHERE where_expression;

Where

  • table_name is an identifier.

Semantics

  • An error is raised if the specified table_name does not exist.
  • The where_expression must evaluate to boolean values.

WHERE Clause

  • The where_expression should specify conditions for all primary-key columns for fast read.

See Also

CREATE TABLEINSERTSELECTUPDATEOther PostgreSQL Statements