Re: postgres metadata

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: postgres metadata
Дата
Msg-id 20031126174134.GB15041@dcc.uchile.cl
обсуждение исходный текст
Ответ на postgres metadata  (Barbara Lindsey <blindsey@cog.ufl.edu>)
Список pgsql-general
On Wed, Nov 26, 2003 at 11:20:54AM -0500, Barbara Lindsey wrote:
> Is there something in Postgres that corresponds to the rowid
> pseudocolumn in Oracle, which represents the unique address of the row
> of data in the table?  If so, how would you access that in a query?

Maybe ctid?  It's the physical column position, so it changes as soon as
the row is UPDATEd, or even during VACUUM.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"La espina, desde que nace, ya pincha" (Proverbio africano)

В списке pgsql-general по дате отправления:

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: cross table indexes?
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: PostgreSQL is much faster than MySQL, only when...