On Thu, May 11, 2006 at 10:41:51AM -0600, Blair Lowe wrote:
> [root@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@www etc]# pg_dump -s temp99 | grep 'CREATE.*bbs_auth_access'
> CREATE TABLE bbs_auth_access (
> [root@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@svana.org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.