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

From Alvaro Herrera
Subject Re: best way to reference tables
Date
Msg-id 20050809202415.GF21039@alvh.no-ip.org
Whole thread Raw
In response to Re: best way to reference tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: best way to reference tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Tue, Aug 09, 2005 at 04:01:33PM -0400, Tom Lane wrote:
> "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.

Maybe it is possible to use a column of type regclass to store it.  Not
sure exactly what advantage that would give, but it's an idea.

--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
"El miedo atento y previsor es la madre de la seguridad" (E. Burke)

pgsql-general by date:

Previous
From: Richard_D_Levine@raytheon.com
Date:
Subject: Re: Testing of MVCC
Next
From: "Guy Rouillier"
Date:
Subject: Re: How to write jobs in postgresql