Skip site navigation (1) Skip section navigation (2)

Re: ROWID ? or other internal ID

From: Jean-Luc Lachance <jllachan(at)nsd(dot)ca>
To: valcauda Stéphane <valcauda(dot)aderis(at)wanadoo(dot)fr>
Cc: PostgreSQL Mailing List <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: ROWID ? or other internal ID
Date: 2002-10-08 17:18:57
Message-ID: 3DA31381.E93DF434@nsd.ca (view raw or flat)
Thread:
Lists: pgsql-odbc
You want OID as in:

Select OID, * from table;


valcauda Stéphane wrote:
> 
> I'm beginner with postgresql.
> In other database like ORACLE or PROGRESS you've got an internal identifier
> ROWID or RECID
> (bookmark with access) which allow you to select a row very quickly or to go
> back to a specific row very quickly.
> these functions uses an internal ID.
> 
> Does something approaching that exist under postgresql ?
> I've search and found nothing except "SERIAL" but that's not an internal ID.
> 
> thanks,
> 
> Stéphane Valcauda
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

In response to

pgsql-odbc by date

Next:From: Tom LaneDate: 2002-10-09 04:55:53
Subject: Re: ROWID ? or other internal ID
Previous:From: valcauda StéphaneDate: 2002-10-08 17:17:38
Subject: ROWID ? or other internal ID

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group