Re: FW: Getting information about sequences

"Forums @ Existanze" <forums(at)existanze(dot)com> writes:
> We are creating a jdbc backup solution that does NOT require the pgdump
> program.

In heaven's name, WHY?

Do you have any idea how much future pain you are setting yourself up
for? pg_dump changes with every PG release to deal with new features
and changes in the system catalogs. Read the CVS logs for pg_dump for
the past few years, then ask yourself if you really want to buy into a
comparable amount of ongoing maintenance effort.

You'd be way better off just invoking pg_dump as a subprocess. If there
are specific features you need that pg_dump doesn't have (eg, dumping
just selected tables) consider helping to add them.

regards, tom lane