APPEND INTO?

From: Mark Fenbers <Mark(dot)Fenbers(at)noaa(dot)gov>
To: PostgreSQL - SQL <pgsql-sql(at)postgresql(dot)org>
Subject: APPEND INTO?
Date: 2005-12-01 14:23:06
Message-ID: 438F074A.3040004@noaa.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jaime Casanova 2005-12-01 15:32:02 Re: APPEND INTO?
Previous Message Tom Lane 2005-11-30 22:27:58 Re: Quote_literal()