Re: APPEND INTO? - Mailing list pgsql-sql

From Tom Lane
Subject Re: APPEND INTO?
Date
Msg-id 10995.1133451128@sss.pgh.pa.us
Whole thread Raw
In response to APPEND INTO?  (Mark Fenbers <Mark.Fenbers@noaa.gov>)
List pgsql-sql
Mark Fenbers <Mark.Fenbers@noaa.gov> writes:
> 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?

INSERT INTO foo SELECT whatever
        regards, tom lane


pgsql-sql by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: APPEND INTO?
Next
From: Emil Rachovsky
Date:
Subject: Sybase Connection_Property('number') equivalent in PostGre ?