Re: pg_dump/restore and functions/triggers/trigger functions

Jeff Amiel <becauseimjeff(at)yahoo(dot)com> writes:
> I guess the real question is (other than related to this issue), it there any need to dump the catalog/informational schemas?

There isn't, but pg_dump won't dump them anyway; you have no need to
specify switches for that.

The whole business of partial dumps and selective restores is still
pretty messy :-(. IIRC pg_dump doesn't have any concept of dumping
or restoring all the objects that a desired object depends on; but
without that, any kind of selectivity is hard to use. My recommendation
at the moment is to always do complete dumps --- you can filter during
pg_restore if you have to, but if your back is against the wall and your
only up-to-date dump is critically incomplete, you're screwed.

regards, tom lane