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  (Fabrice Chapuis <fabrice636861@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg_restore remap schema
Следующее
От: Saul Perdomo
Дата:
Сообщение: Re: 20220722-pg_dump: error: invalid number of parents 0 for table