Re: Exporting just schema/metadata (w/o data) in Postgres
| От | Gandalf Me |
|---|---|
| Тема | Re: Exporting just schema/metadata (w/o data) in Postgres |
| Дата | |
| Msg-id | 118a2f0c0510010535s50c8d927i1210646a0582f73c@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Exporting just schema/metadata (w/o data) in Postgres ("Joshua D. Drake" <jd@commandprompt.com>) |
| Ответы |
Re: Exporting just schema/metadata (w/o data) in Postgres
Re: Exporting just schema/metadata (w/o data) in Postgres |
| Список | 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@commandprompt.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/
В списке pgsql-general по дате отправления: