This page in other versions: Unsupported versions: 7.0

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.
Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group