Re: Unable to determine what has a particular OID - Mailing list pgsql-general

Andy Dale <andy.dale@gmail.com> writes:

>> Try:
>> SELECT oid,* from pg_database ;
>>
>> I suspect the relfilnode you are looking at is another database in the
>> cluster.

> Maybe I am possibly doing that.

There isn't any "maybe" involved here.  Follow Adrian's advice and
determine for sure exactly which database that subdirectory represents.
The subdirectory name will match the OID in the pg_database row.

It's possible for the same table OID to be in use in more than one
database, so the fact that you got a match to the other table doesn't
in itself prove you're looking at the right database.

                       regards, tom lane