felix@xxxxxxxxxxx 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general