Thread: access to internal rowIds

access to internal rowIds

From
adb
Date:
Is there a way to get the internal rowId's in postgres
in a regular query?

Thanks,

Alex.


Re: access to internal rowIds

From
Bruce Momjian
Date:
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