copying between Postgres databases

Поиск
Список
Период
Сортировка
От javier garcia - CEBAS
Тема copying between Postgres databases
Дата
Msg-id 200303170910.h2H9Ar217950@natura.cebas.csic.es
обсуждение исходный текст
Ответы Re: copying between Postgres databases  (Joshua Moore-Oliva <josh@chatgris.com>)
Re: copying between Postgres databases  (Andrew Sullivan <andrew@libertyrms.info>)
Re: copying between Postgres databases  ("scott.marlowe" <scott.marlowe@ihs.com>)
Список pgsql-general
Hi;
I've got two questions:

1) What is the best way to copy a Postgres table in one database into another
Postgres database? Is it possible to copy the structure and the data at the
same time?

2) Is there a way to do a short of pg_dump and to use the resulting file as
input to another database, but preserving existing tables in this latter?

Thanks and regards

Javier

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

Предыдущее
От: Lincoln Yeoh
Дата:
Сообщение: Re: type-casting and LIKE queries
Следующее
От: Joshua Moore-Oliva
Дата:
Сообщение: Re: copying between Postgres databases