GENERAL - Database schema dumper


2009-06-29T22:16:22+00:00

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

Re: GENERAL - Database schema dumper by Thomas Kellerer on 2009-06-29T22:22:21+00:00
felix@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 something that could work for other databases too,
> including Ohttp://www.sql-workbench.net/manual/wb-commands.html#command-schema-report

Regards
Thomas



Re: GENERAL - Database schema dumper by Scott Marlowe on 2009-06-29T22:33:21+00:00
On Mon, Jun 29, 2009 at 4:08 PM, <felix@crowfix.com> wrote:
> I'd like to dump a database schema to a file, probably XML but
> anything reasonable is good enough. =A0By "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 Ohttp://www.postgresql.org/mailpref/pgsql-general

Re: GENERAL - Database schema dumper by on 2009-06-29T23:07:59+00:00
On Mon, Jun 29, 2009 at 04:32:46PM -0600, Scott Marlowe wrote:

> Have you tried pg-dump -s yet?

Wellll .... 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 PostgreSQL
only, not any chance of converting it for use with other databases.


Re: GENERAL - Database schema dumper by on 2009-06-29T23:10:52+00:00
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 explore it a bit tonight.  Looks
like a lot of work has gone into it.


Re: GENERAL - Database schema dumper by Mirko Sertic on 2009-06-30T06:08:36+00:00
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

felix@crowfix.com schrieb:
> 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>
>   


Loading


$ This page is proudly powered by www.pubbs.net, you can see more at pgsql archive | Partners: Global Manufacturers