Copying rows between tables?

Поиск
Список
Период
Сортировка
От Steve Wampler
Тема Copying rows between tables?
Дата
Msg-id 1074011028.18994.18.camel@weaver.tuc.noao.edu
обсуждение исходный текст
Ответы Re: Copying rows between tables?
Re: Copying rows between tables?
Список 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 по дате отправления:

Предыдущее
От: Sai Hertz And Control Systems
Дата:
Сообщение: Re: Problems with postgresql 7.4.1 configuration - URGENT
Следующее
От: "Viorel Dragomir"
Дата:
Сообщение: Re: Copying rows between tables?