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.

Joshua D. Drake




TTYL,
Blair.


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq



--

           === 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/



---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq

Reply via email to