Dumping a table from one database and adding it to another

Поиск
Список
Период
Сортировка
От James B. Byrne
Тема Dumping a table from one database and adding it to another
Дата
Msg-id 38759.216.185.71.25.1291322988.squirrel@webmail.harte-lyne.ca
обсуждение исходный текст
Ответы Re: Dumping a table from one database and adding it to another  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: Dumping a table from one database and adding it to another  (Adrian Klaver <adrian.klaver@gmail.com>)
Список pgsql-general
I have read the documentation respecting backups but I cannot seem
to find any mention of the specific case that I wish performed.

I have a pair of tables in a production database that I wish to dump
and then restore to a new, different database.  I can, and probably
will, recreate the tables and column layouts in the new database.

Is there a way to load the data dumped from a single table in one
database into a new, possibly differently named, table in a
different database, using PG utilities?


--
***          E-Mail is NOT a SECURE channel          ***
James B. Byrne                mailto:ByrneJB@Harte-Lyne.ca
Harte & Lyne Limited          http://www.harte-lyne.ca
9 Brockley Drive              vox: +1 905 561 1241
Hamilton, Ontario             fax: +1 905 561 0757
Canada  L8E 3C3


В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Looking for auto starting procedures
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Dumping a table from one database and adding it to another