access to internal rowIds

Started by adbabout 25 years ago2 messagesgeneral
Jump to latest
#1adb
adb@Beast.COM

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

Thanks,

Alex.

#2Bruce Momjian
bruce@momjian.us
In reply to: adb (#1)
Re: access to internal rowIds

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