"Patrick Hatcher" <PHatcher@macys.com> writes:
> 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?
7.4's pg_dump has an option to dump the contents of just one schema.
regards, tom lane