export/import from one schema to another?

Поиск
Список
Период
Сортировка
От Les Carter
Тема export/import from one schema to another?
Дата
Msg-id 1108364091.4918@workhorse.newkinetics.com
обсуждение исходный текст
Список pgsql-novice
This is a multi-part message in MIME format.

--bound1108364091
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 7bit

I've seen the pg_dump utility which backs up a database with which you can then use psql to restore but I was wondering
howdo you go about doing an import/export (like you can do with Oracle) where you can export info from one schema and
usethat as a reference point and import that data into other schemas to make replicas. 

Hopefully someone can cast some light on this that would be a little cleaner than having to search/replace in the dump
filefor the schema name. 

Cheers,

L

--bound1108364091--


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

Предыдущее
От: "Keith Worthington"
Дата:
Сообщение: CASTING in JOIN or WHERE
Следующее
От: "Kevin Crenshaw"
Дата:
Сообщение: Re: Revision Control