Deletions

PostgreSQL Tutorial
Prev	Chapter 5. The Query Language	Next

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.

Prev	Home	Next
Updates	Up	Using Aggregate Functions