Copying rows between tables? - Mailing list pgsql-sql

From Steve Wampler
Subject Copying rows between tables?
Date
Msg-id 1074011028.18994.18.camel@weaver.tuc.noao.edu
Whole thread Raw
Responses Re: Copying rows between tables?
Re: Copying rows between tables?
List pgsql-sql
I know I can select from one table into a new table, but is
there a way to select from one table into an existing table
(aside from copying everything to a file, editing the file
and then copying from that file)?  Without destroying existing
entries, of course...

I have an application where old records are archived into
'archive' tables.  Occasionally there is a need to copy
some of these old records into the 'active' table.

Thanks for any pointers!
Steve
-- 
Steve Wampler -- swampler@noao.edu
The gods that smiled on your birth are now laughing out loud.


pgsql-sql by date:

Previous
From: Sai Hertz And Control Systems
Date:
Subject: Re: Problems with postgresql 7.4.1 configuration - URGENT
Next
From: "Viorel Dragomir"
Date:
Subject: Re: Copying rows between tables?