On Thursday, March 29, 2012 05:03:03 PM Binand Sethumadhavan wrote:
> What I typically do is to attach "where 1 = 0" to inhibit a query from
> making any changes, if I find an error in a multiline query and do not
> want to Control-C out of psql.
It is also a good idea to always always do a "begin" before doing any manual
update, and only commit changes if it looks like it did the right thing.