Re: best way to reference tables

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: best way to reference tables
Дата
Msg-id 18564.1123617693@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: best way to reference tables  ("TJ O'Donnell" <tjo@acm.org>)
Ответы Re: best way to reference tables  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список 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 по дате отправления:

Предыдущее
От: brew@theMode.com
Дата:
Сообщение: Re: Poll on your LAPP Preferences
Следующее
От: Richard_D_Levine@raytheon.com
Дата:
Сообщение: Re: Testing of MVCC