Re: [SQL] Undo A Delete - Mailing list pgsql-sql

From Brett W. McCoy
Subject Re: [SQL] Undo A Delete
Date
Msg-id Pine.BSI.3.91.990902162726.8793P-100000@access1.lan2wan.com
Whole thread Raw
In response to Undo A Delete  (Darren Greer <dgreer@websightsolutions.com>)
List pgsql-sql
> I dont supose there is a way to undo, or restore, a "delete from table
> where...."?

Use transactions (BEGIN, COMMIT, ROLLBACK, etc.)  If you delete data 
inside of a transaction and then rollback, your data will be restored.  
At least I think that's how it's supposed to work!

Brett W. McCoy                                                   http://www.lan2wan.com/~bmccoy
-----------------------------------------------------------------------
The wind doth taste so bitter sweet,Like Jaspar wine and sugar,
It must have blown through someone's feet,Like those of Caspar Weinberger.    -- P. Opus



pgsql-sql by date:

Previous
From: Darren Greer
Date:
Subject: Undo A Delete
Next
From: "pvsree"
Date:
Subject: About table cteation from an sql file