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@xxxxxxxxx> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.
Attachment:
signature.asc
Description: Digital signature
