On Monday 29 June 2009, felix@crowfix.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