"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