Re: Database schema dumper

On Monday 29 June 2009, felix(at)crowfix(dot)com said something like:
> I'd like to dump a database schema to a file, probably XML but
> anything reasonable is good enough. By "schema", I don't mean the
> narrow postgres keyword, but rather the table names, columns,
> foreignkeys, triggers, constraints, etc.
>
> I'd really like something that could work for other databases too,
> including O-----, M----, etc. But that might be asking too much.
>
> A quick google for variations on "dump database schema" didn't find
> much.
>
> Whether it be a CPAN module, Java class, etc, or a standalone
> program, none of that matters much.

You mentioned CPAN, so I assume you're comfortable with Perl. It's Pg
specific, but it's a GREAT utility:

http://www.rbt.ca/autodoc/

Does output in HTML, Dot, Dia,, and XML.

j

--
Joshua Kugler
Part-Time System Admin/Programmer
http://www.eeinternet.com
PGP Key: http://pgp.mit.edu/  ID 0xDB26D7CE