Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT INTO but append not create new table - How? - Mailing list pgsql-novice

From Tom Lane
Subject Re: SELECT INTO but append not create new table - How?
Date
Msg-id 5513.1075256898@sss.pgh.pa.us
Whole thread Raw
In response to SELECT INTO but append not create new table - How?  ("Alan T. Miller" <amiller@hollywood101.com>)
List pgsql-novice
Tree view 
"Alan T. Miller" <amiller@hollywood101.com> writes:
> I messed around with the 'INSERT INTO' SQL command, but this assumes that
> the table you are 'selecting into' does not exist and you want to create
> that table. My problem is that the table exists and I just want to append
> the information to the archive table.

I think you are looking for INSERT ... SELECT.  See the INSERT man page
or any book about SQL.

            regards, tom lane

pgsql-novice by date:

Previous
From: "Alan T. Miller"
Date:
Subject: SELECT INTO but append not create new table - How?
Next
From: "Alan T. Miller"
Date:
Subject: Re: SELECT INTO but append not create new table - How?