Re: pg_dump and grants to PUBLIC

This option shows up in 7.4.
On Friday 12 May 2006 10:16 am, Blair Lowe wrote:
> On Fri, 2006-12-05 at 10:08 -0700, Adrian Klaver wrote:
> > On Friday 12 May 2006 09:50 am, Blair Lowe wrote:
> > See following-
> > -n schema
> > --schema=schema
> >
> > Dump the contents of schema only. If this option is not specified,
> > all non-system schemas in the target database will be dumped.
> >
> > Note: In this mode, pg_dump makes no attempt to dump any other
> > database objects that objects in the selected schema may depend upon.
> > Therefore, there is no guarantee that the results of a single-schema dump
> > can be successfully restored by themselves into a clean database.
>
> In postgreSQL version 7.3.4:
>
> user# pg_dump -n <schema_name> > tmp95.sql
> pg_dump: invalid option -- n
> Try 'pg_dump --help' for more information.
>
> phpbb only works with version 7.x.
>
> TTYL,
> Blair.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings

--
Adrian Klaver
aklaver(at)comcast(dot)net