From: | Gandalf Me <gandalf(dot)me(at)gmail(dot)com> |
---|---|
To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Exporting just schema/metadata (w/o data) in Postgres |
Date: | 2005-10-01 12:35:27 |
Message-ID: | 118a2f0c0510010535s50c8d927i1210646a0582f73c@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 understand different DBs ahve different types and one need to do the
mapping and all, but does such a generic tool exists.
Regards.
On 9/30/05, Joshua D. Drake <jd(at)commandprompt(dot)com> wrote:
>
> 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. Drake
>
>
> >
> > Thanks in advance.
> >
>
>
> --
> Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
> PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
> Managed Services, Shared and Dedicated Hosting
> Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/
>
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2005-10-01 12:53:57 | Re: Exporting just schema/metadata (w/o data) in Postgres |
Previous Message | hubert depesz lubaczewski | 2005-10-01 10:01:04 | Re: database bloat, but vacuums are done, and fsm seems to be setup ok |