Re: Deduce table name from OID?

From: Richard Huxton <dev(at)archonet(dot)com>
To: Zak McGregor <zak(at)mighty(dot)co(dot)za>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Deduce table name from OID?
Date: 2001-07-06 07:02:59
Message-ID: 3B4562A3.BB56C2A5@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Zak McGregor wrote:
>
> Does anyone know if it is possible to work out from an OID alone which
> table it references?

richardh=> select oid,relname from pg_class where oid=1044019;
oid | relname
---------+---------
1044019 | foo

HTH

- Richard Huxton

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Eric Chacon 2001-07-06 11:11:05 Stored Procedure Newbie
Previous Message Lincy Lin 2001-07-06 05:14:36 RE: Re: 7.1.2 ERROR: UNIQUE constraint matching given keys for referenced table ......