idiom to move records?

From: Leslie Mikesell <les(at)Mcs(dot)Net>
To: pgsql-sql(at)postgreSQL(dot)org
Subject: idiom to move records?
Date: 1998-10-26 05:31:05
Message-ID: 199810260531.XAA14075@Mars.mcs.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Is there a handy way to move a set of records to a different
table in sql? I'd like to do this based on a WHERE clause
and have it work atomically such that it will not lose new
records added between the step that copies to the other table
and deleting the copied records.

Les Mikesell
les(at)mcs(dot)com

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Mike Meyer 1998-10-26 08:19:12 Help on extensended attribute types?
Previous Message Michael Olivier 1998-10-26 05:13:18 palloc failure: memory exhausted, but ulimit 'unlimited'