This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the
current
version, or one of the other supported versions listed above instead.
| PostgreSQL |
| Prev |
Chapter 4. The
Query Language |
Next |
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.