How do I copy part of table from db1 to db2 (and rename the columns)?

Поиск
Список
Период
Сортировка
Искать
От
Joost Kraaijeveld
Тема
How do I copy part of table from db1 to db2 (and rename the columns)?
Дата
Msg-id
1125482430.9456.6.camel@Panoramix
Список
Дерево обсуждения
How do I copy part of table from db1 to db2 (and rename the columns)? Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
Re: [GENERAL] How do I copy part of table from db1 to db2 (and rename the columns)? Roman Neuhauser <neuhauser@sigpipe.cz>
Re: [GENERAL] How do I copy part of table from db1 to db2 (and Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
Re: [GENERAL] How do I copy part of table from db1 to db2 (and Tom Lane <tgl@sss.pgh.pa.us>
Re: [GENERAL] How do I copy part of table from db1 to db2 Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
Re: [GENERAL] How do I copy part of table from db1 to db2 (and Thomas Pundt <mlists@rp-online.de>
Re: [GENERAL] How do I copy part of table from db1 to db2 (and Thomas Pundt <mlists@rp-online.de>
Re: [GENERAL] How do I copy part of table from db1 to db2 Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
Re: [GENERAL] How do I copy part of table from db1 to db2 (and Tino Wildenhain <tino@wildenhain.de>
Re: How do I copy part of table from db1 to db2 (and rename the columns)? Kenneth Gonsalves <lawgon@thenilgiris.com>
Re: How do I copy part of table from db1 to db2 (and rename the columns)? "Greg Sabino Mullane" <greg@turnstep.com> 
Hi,

I want to copy several columns of a source table from db1 to db2, and
create the target table and rename the columns in the process. 

Is that possible in PostgresQL? If so, an example or url for such a
command /script would be appreciated...

TIA

Joost
В списке pgsql-sql по дате отправления
Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: [ADMIN] plpgsql question
Следующее
От: Kenneth Gonsalves
Дата:
FAQ