Re: pg_dump and grants to PUBLIC

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.
> >
> > O.k. if you are actually using schemas, then pass the schema parameter
> > to pg_dump and you won't get other information.
>
> Thanks Joshua,
>
> According to the man page:
> -s
> --schema-only
> Dump only the schema (data definitions), no data.
>
> I need data too.
>
> What are the command line options to get a user's schema, and a user's
> data?
>
> Thanks,
> Blair
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster

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