Hi all, I am interested in the answer as well -- how to get a table name (or an operator name) from an OID. the parser must know how to do this, but the segment of code is hard to locate.
thanks a lot, Huaxin On 11/7/05, Paresh Bafna <[EMAIL PROTECTED]> wrote: > Actually I want to do this from inside the postgres code i.e. I want to > get table name and tuple values from OID of corresponding table OID and > tuple OID. > Is there any built in function in postgres code to do this? > > Paresh > > Christopher Kings-Lynne wrote: > > > Try > > > > SELECT 12341234::regclass; > > > > Where 12341234 is the OID of a table. > > > > Otherwise try: > > > > SELECT tableoid, * FROM table; > > > > To get the tableoid on each row. > > > > Chris > > > > Paresh Bafna wrote: > > > >> Is there any way to retrieve table name and/or tuple values from OID of > >> table/tuple? > >> > >> ---------------------------(end of broadcast)--------------------------- > >> TIP 5: don't forget to increase your free space map settings > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 5: don't forget to increase your free space map settings > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings > ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
