Re: pg_dump and grants to PUBLIC

On Thu, May 11, 2006 at 10:41:51AM -0600, Blair Lowe wrote:
> [root(at)www etc]# psql temp99
> Welcome to psql 7.3.4, the PostgreSQL interactive terminal.
>
> Type: \copyright for distribution terms
> \h for help with SQL commands
> \? for help on internal slash commands
> \g or terminate with semicolon to execute query
> \q to quit
>
> temp99=# select oid from pg_class where relname = 'bbs_auth_access';
> oid
> -------
> 17736
> (1 row)
> temp99=# \q
> [root(at)www etc]# pg_dump -s temp99 | grep 'CREATE.*bbs_auth_access'
> CREATE TABLE bbs_auth_access (
> [root(at)www etc]#

Eh? All you've proved here was that a table that is in that database
also appears in the dump. You need to show a case where the select
return no rows ie. the table doesn't exist in the database but does
exist in the dump.

> What is the SQL to find the oid 17736?

Well, the inverse of what you did above.

select relname from pg_class where oid = <oid>;

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.