Thread: Dump Schema?

pg_dump -s dbname

Chris Ruprecht (chrup999@yahoo.com) 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?
>
> Best regards,
> Chris
>

--
http://schvin.net/

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@zf.jcu.cz>
 http://home.zf.jcu.cz/~zakkr/

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