Split pg_dump dump into files and then combine it back

Поиск
Список
Период
Сортировка
От Dmitry Koterov
Тема Split pg_dump dump into files and then combine it back
Дата
Msg-id d7df81621001141601v387cdb03gbf86da54d824cce8@mail.gmail.com
обсуждение исходный текст
Ответы Re: Split pg_dump dump into files and then combine it back  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hello.

Is there a tool (or a way) to parse a pg_dump'ed (structure only) dump file into smaller files (each function in its own file, its table in its own etc.) with ability to combine these files later into the proper dump file?

The main problem is dependencies. Sometimes functions are defined before types, sometimes after. The same for cross-schema references. Dump parsing is simple, but this process drops dependencies between objects and could not be reversed easily.

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

Предыдущее
От: David Kerr
Дата:
Сообщение: Re: Moving database cluster
Следующее
От: John R Pierce
Дата:
Сообщение: Re: Avoid transaction abot if/when constraint violated