Postgres Pro
Downloads
Home   >   mailing lists

Re: Deduce table name from OID? - Mailing list pgsql-general

From Richard Huxton
Subject Re: Deduce table name from OID?
Date
Msg-id 3B4562A3.BB56C2A5@archonet.com
Whole thread Raw
In response to Deduce table name from OID?  (Zak McGregor <zak@mighty.co.za>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Joshua Jore
Date:
Subject: Re: OpenBSD Trusted Path Execution (TPE) compatibility?
Next
From: Daniel Åkerud
Date:
Subject: Transactions within a function