Re: SELECT INTO but append not create new table - How?

"Alan T. Miller" <amiller@xxxxxxxxxxxxxxxx> 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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)