Split pg_dump dump into files and then combine it back

From: Dmitry Koterov <dmitry(at)koterov(dot)ru>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Split pg_dump dump into files and then combine it back
Date: 2010-01-15 00:01:19
Message-ID: d7df81621001141601v387cdb03gbf86da54d824cce8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2010-01-15 00:17:46 Re: Avoid transaction abot if/when constraint violated
Previous Message David Kerr 2010-01-14 23:55:55 Re: Moving database cluster