Re: best way to reference tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: tjo(at)acm(dot)org
Cc: dev(at)archonet(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: best way to reference tables
Date: 2005-08-09 20:01:33
Message-ID: 18564.1123617693@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"TJ O'Donnell" <tjo(at)acm(dot)org> writes:
> I guess what I'm asking is: Is there a better way to keep track of a
> table once it's registered in my master table than just to put its
> name in my master table? Some system oid type thing that stays fixed
> in spite of renames or other tables mods?

Yeah, you can store the pg_class OID of the table, instead of (or in
addition to) its name. This is exactly what the system itself considers
to be the "identity" of the table.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2005-08-09 20:24:15 Re: best way to reference tables
Previous Message Richard_D_Levine 2005-08-09 20:00:52 Re: Testing of MVCC