Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2010
    Posts
    10

    Unanswered: how postgres recognize a record uniquely internally

    Hi all.
    I am using postgres 8.4.
    In Oracle each record in a table is recognize by the 'row_id'. Which is maintained by Oracle itself. By the row_id Oracle recognize a record in a table distinctly. Likewise in Postgres, how Postgres recognize a record distinctly. Is it maintaining a 'row_id' like Oracle.

    Please tell me the concepts about it.

    Thanks
    Debadutta

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    First: in Oracle it's called ROWID (not row_id)
    The equivalent in Postgres is ctid

    More information is in the manual
    http://www.postgresql.org/docs/curre...m-columns.html

  3. #3
    Join Date
    Aug 2009
    Location
    Olympia, WA
    Posts
    337
    You'd shouldn't need ctid very often, use the pk when ever possible. In older versions of Oracle the rowid was the fastest way to the record and was used a lot. But its recommended to use PK on Oracle now too.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •