Re: Exporting just schema/metadata (w/o data) in Postgres

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Gandalf Me <gandalf(dot)me(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Exporting just schema/metadata (w/o data) in Postgres
Date: 2005-09-30 16:09:25
Message-ID: 433D6335.8000709@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sergei Dubov 2005-09-30 16:45:21 Many-To-Many Bridge Table Index
Previous Message Gandalf Me 2005-09-30 15:52:28 Exporting just schema/metadata (w/o data) in Postgres