Re: dump schema schema only?

You can use -t to specify a table:

% pg_dump -s database -t tablename


-Rick



-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Patrick
Hatcher
Sent: Wednesday, October 29, 2003 12:57 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] dump schema schema only?


I have a development server where I, well, do my development.
Occasionally,
I will create a new schema within an existing database that I would
like to
use on my production machine.   I know that doing a pg_dump -s
<database>
> somefile.sql will dump the entire schema of the database, but is
there a
way to export only schema X from the database?

TIA
Patrick Hatcher



---------------------------(end of
broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to
majordomo@postgresql.org)