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

From Blair Lowe
Subject Re: pg_dump and grants to PUBLIC
Date
Msg-id 1147452626.4575.4.camel@localhost.localdomain
Whole thread Raw
In response to Re: pg_dump and grants to PUBLIC  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: pg_dump and grants to PUBLIC
Re: pg_dump and grants to PUBLIC
List pgsql-general
On Thu, 2006-11-05 at 11:09 -0700, Joshua D. Drake wrote:
> > select relname from pg_class where oid = 17736;
> >      relname
> > -----------------
> > bbs_auth_access
> > (1 row)
> >
> > phpbb_mainlandpc=> \q
> >
> > To access this user's table, I can be logged on as anyone, and that is
> > expected in SQL when there are public grants.
> >
> > I am not expecting to get everyone else's stuff when I run pg_dump, only
> > the stuff in their schema.
>
> 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



pgsql-general by date:

Previous
From: "Hogan, James F. Jr."
Date:
Subject: Re: GUI Interface
Next
From: Richard Broersma Jr
Date:
Subject: Re: GUI Interface