On Monday 29 June 2009, fe...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
