- Previous thread: [GENERAL]
- Next thread: [GENERAL] High consumns memory
- Threads sorted by date: pgsql 200906
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.
--
... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._.
Felix Finch: scarecrow repairman & rocket surgeon / felix@crowfix.com
GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933
I've found a solution to Fermat's Last Theorem but I see I've run out of room o
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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.
--
... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._.
Felix Finch: scarecrow repairman & rocket surgeon / felix@crowfix.com
GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933
I've found a solution to Fermat's Last Theorem but I see I've run out of room o
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
> 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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. =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 O-----, M----, etc. =A0But that might be asking too much.
Have you tried pg_dump -s yet?
--=20
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
> 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 O-----, M----, etc. =A0But that might be asking too much.
Have you tried pg_dump -s yet?
--=20
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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.
--
... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._.
Felix Finch: scarecrow repairman & rocket surgeon / felix@crowfix.com
GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933
I've found a solution to Fermat's Last Theorem but I see I've run out of room o
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
> 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.
--
... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._.
Felix Finch: scarecrow repairman & rocket surgeon / felix@crowfix.com
GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933
I've found a solution to Fermat's Last Theorem but I see I've run out of room o
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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.
--
... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._.
Felix Finch: scarecrow repairman & rocket surgeon / felix@crowfix.com
GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933
I've found a solution to Fermat's Last Theorem but I see I've run out of room o
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
> 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.
--
... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._.
Felix Finch: scarecrow repairman & rocket surgeon / felix@crowfix.com
GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933
I've found a solution to Fermat's Last Theorem but I see I've run out of room o
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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-----, 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.
>
>
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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-----, 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.
>
>
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Related Threads
- [Call for testers] bce(4) update - freebsd
- [PHP] OT? my own posts are invisible to me. How to decloak? - php
- Block device, major- minor ? - debian
- gfortran joy! - gcc
- acroread8 wont work on 6.3 - freebsd
- Rawhide: pulseaudio and emu10k1 problems - fedora
- Fix libgomp failures with -g on SPARC/Solaris - gcc
- Re: [PATCH, testsuite] Fix PR37033, gcc.dg/pch/valid-1b.c failures - gcc