Unsupported versions: 6.4

Historical version. PostgreSQL 6.4 has reached end of support. See the current manual.

Deletions

Deletions are performed using the delete command:

DELETE FROM weather WHERE city = 'Hayward';

All weather recording belongs to Hayward is removed. One should be wary of queries of the form

DELETE FROM classname;

Without a qualification, delete will simply remove all instances of the given class, leaving it empty. The system will not request confirmation before doing this.

Report a documentation issue

Read the upstream documentation. For corrections, first check the current manual.