Re: APPEND INTO?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mark Fenbers <Mark(dot)Fenbers(at)noaa(dot)gov>
Cc: PostgreSQL - SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: APPEND INTO?
Date: 2005-12-01 15:32:08
Message-ID: 10995.1133451128@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Mark Fenbers <Mark(dot)Fenbers(at)noaa(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Emil Rachovsky 2005-12-02 09:04:19 Sybase Connection_Property('number') equivalent in PostGre ?
Previous Message Jaime Casanova 2005-12-01 15:32:02 Re: APPEND INTO?