Re: pg_restore remap schema

Поиск
Список
Период
Сортировка
От Marcos Pegoraro
Тема Re: pg_restore remap schema
Дата
Msg-id CAB-JLwYsuKC8gMAyHqqnFyBubSV+xrbo7rX1k8VGbAzm+1g66g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_restore remap schema  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: pg_restore remap schema
Список pgsql-general
People have asked for such a thing before, but it'd be quite difficult
to do reliably --- particularly inside function bodies, which aren't
normally parsed at all during a dump/restore.  If you're willing to
accept a 95% solution, running the pg_restore output through "sed"
would likely work fairly well.  I'd personally want to diff the
before-and-after scripts before applying though :-)

Another 95% solution, if both schemas are on the same server, google for function clone schema, you´ll find some of them. They create tables, functions, sequences, views, ...

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