Postgres Pro
Downloads
Home   >   mailing lists

Re: id from a field - Mailing list pgsql-novice

From A. Kretschmer
Subject Re: id from a field
Date
Msg-id 20060222184339.GA16167@webserv.wug-glas.de
Whole thread Raw
In response to id from a field  ("Luis Silva" <lfs12@hotmail.com>)
Responses check problem
List pgsql-novice
Tree view 
am  22.02.2006, um 18:32:14 +0000 mailte Luis Silva folgendes:
> I there!! I'm having a problem. I know that it's possible to know the exact
> ID of a table or a column using OIDs but, is it possible to know the ID
> from a field?. for example I have a table named "identities" with 3

If you create the table with oid, yes. And, you have the ctid.
http://www.postgresql.org/docs/faqs.FAQ.html -> 4.12 ctid


HTH, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47215,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

pgsql-novice by date:

Previous
From: "Luis Silva"
Date:
Subject: id from a field
Next
From: Richard Kut
Date:
Subject: Re: plpgsql-function with timestamp