18th October 2018: PostgreSQL 11 Released!
Unsupported versions: 7.1

4.9. Deletions

Deletions are performed using the DELETE command:

DELETE FROM weather WHERE city = 'Hayward';
All weather recording belonging to Hayward are removed. One should be wary of queries of the form
DELETE FROM tablename;
Without a qualification, DELETE will simply remove all rows from the given table, leaving it empty. The system will not request confirmation before doing this.