Postgres Pro
Downloads
Home   >   mailing lists

Re: Get the offset of a tuple inside a table - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: Get the offset of a tuple inside a table
Date
Msg-id 4C98EFC90200002500035AA1@gw.wicourts.gov
Whole thread Raw
In response to Get the offset of a tuple inside a table  (Pei He <hepeimail@gmail.com>)
List pgsql-hackers
Tree view 
Pei He <hepeimail@gmail.com> wrote:
> When I using an index scan, can I get the offset of the tuple in
> the table?
Well, regardless of the type of scan, you can select the ctid
column, which gives the block number and the tuple number within the
block.
-Kevin

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Any reason why the default_with_oids GUC is still there?
Next
From: Tom Lane
Date:
Subject: Re: What happened to the is_ family of functions proposal?