APPEND INTO? - Mailing list pgsql-sql

From Mark Fenbers
Subject APPEND INTO?
Date
Msg-id 438F074A.3040004@noaa.gov
Whole thread Raw
Responses Re: APPEND INTO?  (Jaime Casanova <systemguards@gmail.com>)
Re: APPEND INTO?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
I want to SELECT INTO mytable WHERE (criteria are met), except that I 
want to APPEND into an existing table the rows that are selected, 
instead of creating a new table (which SELECT INTO will do).  How can 
this be done?

(Is this what the "FOR UPDATE OF tablename" clause is for?)

Mark


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Quote_literal()
Next
From: Jaime Casanova
Date:
Subject: Re: APPEND INTO?