Postgres Pro
Downloads
Home   >   mailing lists

Re: create snapshot? - Mailing list pgsql-general

From Tom Lane
Subject Re: create snapshot?
Date
Msg-id 16737.975085894@sss.pgh.pa.us
Whole thread Raw
In response to create snapshot?  (hubert depesz lubaczewski <depesz@depesz.pl>)
List pgsql-general
Tree view 
hubert depesz lubaczewski <depesz@depesz.pl> writes:
> hi, i was wondering if there is something in postgresql like "create
> snapshot".

Seems like "SELECT INTO table" or "CREATE TABLE ... AS SELECT ..."
will do this just fine ...

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Hung backends
Next
From: "Schmidt, Peter"
Date:
Subject: RE: Hung backends