using pg_dump to dump only a schema?

Поиск
Список
Период
Сортировка
От thomas
Тема using pg_dump to dump only a schema?
Дата
Msg-id 429CC318.5040009@gmx.net
обсуждение исходный текст
Ответы Re: using pg_dump to dump only a schema?  (Scott Marlowe <smarlowe@g2switchworks.com>)
Список pgsql-general
hi there,

i'm wondering, if i can use pg_dump to move only one schema of a db from
the one server, intoan other schema on the other server?

for example:

Server A:
Database: xyz_test
Schema: 123

Server B:
Database: xyz_prod
Schema: 999


The tablenames and so on are equal. and i wan't to transfer the data
with it. is it possible? and how? today i played a little bit with it,
but could not find a proper way with it. the description in the docu
didn't helped me either. any solution anyone?

thanx in advance!

bye,
thomas


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: CREATE TEMP TABLE AS SELECT/ GET DIAGNOSTICS ROW_COUNT
Следующее
От: Gianni Mariani
Дата:
Сообщение: Re: Accessing PostgreSQL from C++