Re: Database schema dumper - Mailing list pgsql-general

[email protected] wrote on 30.06.2009 00:08:
> 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.


Take a look at my SQL Workbench/J, especially the WbReport command:

http://www.sql-workbench.net/index.html

http://www.sql-workbench.net/manual/wb-commands.html#command-schema-report

Regards
Thomas