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 ;-)



---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?


Reply via email to