Re: [GENERAL] Database schema dumper

2009-07-02 Thread Joshua J. Kugler
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,

Re: [GENERAL] Database schema dumper

2009-06-29 Thread Mirko Sertic
Hi Try Mogwai ERDesignerNG. it can reverse engineer databases like Postgres, Oracle, MySQL, MSSQL, stores its model as XML files and can also generate DDL from it. Supporting schema comparison, schema evolution and data dictionaries. Regards Mirko fe...@crowfix.com schrieb: I'd like to dump

Re: [GENERAL] Database schema dumper

2009-06-29 Thread felix
On Tue, Jun 30, 2009 at 12:21:22AM +0200, Thomas Kellerer wrote: > 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 That just may do the trick. I'll exp

Re: [GENERAL] Database schema dumper

2009-06-29 Thread felix
On Mon, Jun 29, 2009 at 04:32:46PM -0600, Scott Marlowe wrote: > Have you tried pg_dump -s yet? We I know I said the format is immaterial, and I know I could write something to convert it into something more useful, but it is on the low end of what I was looking for, and is very much Pos

Re: [GENERAL] Database schema dumper

2009-06-29 Thread Scott Marlowe
On Mon, Jun 29, 2009 at 4:08 PM, wrote: > 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 li

Re: [GENERAL] Database schema dumper

2009-06-29 Thread Thomas Kellerer
fe...@crowfix.com 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 so

[GENERAL] Database schema dumper

2009-06-29 Thread felix
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