Re: dump schema schema only?

Harald Fuchs wrote:
> In article <20051(dot)1067459901(at)sss(dot)pgh(dot)pa(dot)us>,
> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
>
> > "Patrick Hatcher" <PHatcher(at)macys(dot)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.
>
> The pg_dump manpage of beta4 does not include this option, although
> the source code does. Has this been fixed in beta5?

Really? Perhaps we haven't updated the manual pages, but the SGML is
OK. I have added this to the list to be done before 7.4 final.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073