When I worked at United Devices we created an XML schema representation
that did a number of things:
Created schemas for DB2, Oracle, and eventually PostgreSQL
Created many simple stored procs automatically (DB2 and Oracle
syntax-check stored procs at compile, so this was a great way to catch
bad
On Sat, Oct 01, 2005 at 06:05:27PM +0530, Gandalf Me wrote:
> Thanks!
> Is there a tool which allows me to import this metadata across different
> databases (postgres, oracle, db2)? Any standard format for storing the
> metadata.
> Basically, I want my application to run on multiple DBs, and I wa
Thanks!
Is there a tool which allows me to import this metadata across different databases (postgres, oracle, db2)? Any standard format for storing the metadata.
Basically, I want my application to run on multiple DBs, and I want to create the same schema in all DBs with minimal effort.
I und
Gandalf Me wrote:
I was just wondering if we can export just the schema/metadata in
Postgres (i.e. just the table and column information, without the data).
Is there an easy way to do this in Postgres?
pg_dump --help is your friend.
You are looking for the -s flag.
Sincerely,
Joshua D. Drak
I was just wondering if we can export just the schema/metadata in Postgres (i.e. just the table and column information, without the data). Is there an easy way to do this in Postgres?
Thanks in advance.
