Joshua D. Drake wrote:
I think what you may really be after is "the stuff that should be
loaded
before inserting data" and "the stuff that should be loaded after",
but
the above are poor names for these concepts.
But it certainly would be nice to be able to dump all that "stuff":-)
Yea, I've been told that this would not be a high demand feature. So
do I have a second vote? ;-)
The ability to have a dump that automatically separated the
before-data and after-data objects is definitely
useful. The amount of times I have had to dump the schema and data
separately just so I can modify the
schema before restore, or disable some function that is causing
problems can not even be counted.
We already have a highly selective and configurable restore mechanism,
using the -L feature of pg_restore. Maybe there's a good special case
for this particular split, but it is hardly undoable now.
As for Naz' needs - I gave him a perl script I whipped up in few minutes
to do the split he wanted - and I'm sure you could do the same in python ;-)
cheers
andrew
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org