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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-odbc by date

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