Обсуждение: access to internal rowIds

Поиск
Список
Период
Сортировка

access to internal rowIds

От
adb
Дата:
Is there a way to get the internal rowId's in postgres
in a regular query?

Thanks,

Alex.


Re: access to internal rowIds

От
Bruce Momjian
Дата:
SELECT OID, col FROM tab.

OID is the rowid.

> Is there a way to get the internal rowId's in postgres
> in a regular query?
>
> Thanks,
>
> Alex.
>
>


--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026