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 Wampler -- swampler(at)noao(dot)edu
The gods that smiled on your birth are now laughing out loud.
pgsql-sql by date
|Next:||From: Viorel Dragomir||Date: 2004-01-13 16:30:47|
|Subject: Re: Copying rows between tables?|
|Previous:||From: Sai Hertz And Control Systems||Date: 2004-01-13 16:01:43|
|Subject: Re: Problems with postgresql 7.4.1 configuration - URGENT|