Thanks. That's what I had thought, but I just wanted to make sure. I'll use psql (or write a perl script).
On Sat, Jul 7, 2012 at 11:24 AM, Guillaume Lelarge <guilla...@lelarge.info>wrote: > On Sat, 2012-07-07 at 10:45 -0500, Michael Shapiro wrote: > > Is it possible to run an update in the background? I have an update to > 23+ > > million records that will very likely take a few hours. > > Is it possible to issue the update in PgAdmin, and then exit PgAdmin and > > have the update continue on the server? > > No, that's not possible. As soon as you quit pgadmin, the connection is > dropped, and your statement is rollbacked. > > > -- > Guillaume > http://blog.guillaume.lelarge.info > http://www.dalibo.com > >