Re: pg_dump and grants to PUBLIC

> 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?

You are confusing "The Schema" with "Schemas". It is a common mistake:

  -n, --schema=SCHEMA      dump the named schema only


Joshua D. Drake

>
> Thanks,
> Blair
>
>


--

            === The PostgreSQL Company: Command Prompt, Inc. ===
      Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
      Providing the most comprehensive  PostgreSQL solutions since 1997
                     http://www.commandprompt.com/