"Patrick Hatcher" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend