Re: Dump Schema?

From: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
To: Chris Ruprecht <chrup999(at)yahoo(dot)com>
Cc: p-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Dump Schema?
Date: 2001-07-27 14:18:41
Message-ID: 20010727161841.A5504@ara.zf.jcu.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, Jul 27, 2001 at 08:55:05AM -0500, Chris Ruprecht wrote:
> Hi guys,
>
> I have a database on my production machine and I want a copy of this db (9 GB) - without the data - on a development machine (notebook with about 6 GB of space).
> How can I just dump the schema without the data? Is there a simple command for that?
>

pg_dump

-s, --schema-only dump out only the schema, no data

Something is bad on docs or pg_dump --help? :-)

Karel

--
Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/

C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Chris Ruprecht 2001-07-27 14:38:14 Re: Dump Schema?
Previous Message George Lewis 2001-07-27 14:10:38 Re: Dump Schema?