Re: pg_dump and grants to PUBLIC - Mailing list pgsql-general

From Adrian Klaver
Subject Re: pg_dump and grants to PUBLIC
Date
Msg-id 200605121046.40744.aklaver@comcast.net
Whole thread Raw
In response to Re: pg_dump and grants to PUBLIC  (Blair Lowe <postgresql@zedemail.ca>)
Responses Re: pg_dump and grants to PUBLIC  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
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@comcast.net

pgsql-general by date:

Previous
From: Tony Caduto
Date:
Subject: Re: GUI Interface
Next
From: "Joshua D. Drake"
Date:
Subject: Re: pg_dump and grants to PUBLIC