Re: best way to reference tables - Mailing list pgsql-general

From Tom Lane
Subject Re: best way to reference tables
Date
Msg-id 18564.1123617693@sss.pgh.pa.us
Whole thread Raw
In response to Re: best way to reference tables  ("TJ O'Donnell" <tjo@acm.org>)
Responses Re: best way to reference tables  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-general
"TJ O'Donnell" <tjo@acm.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

pgsql-general by date:

Previous
From: brew@theMode.com
Date:
Subject: Re: Poll on your LAPP Preferences
Next
From: Richard_D_Levine@raytheon.com
Date:
Subject: Re: Testing of MVCC