Split pg_dump dump into files and then combine it back - Mailing list pgsql-general

From Dmitry Koterov
Subject Split pg_dump dump into files and then combine it back
Date
Msg-id d7df81621001141601v387cdb03gbf86da54d824cce8@mail.gmail.com
Whole thread Raw
Responses Re: Split pg_dump dump into files and then combine it back  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: David Kerr
Date:
Subject: Re: Moving database cluster
Next
From: John R Pierce
Date:
Subject: Re: Avoid transaction abot if/when constraint violated