Re: prepare, execute & oids - Mailing list pgsql-general

From Michael Fuhr
Subject Re: prepare, execute & oids
Date
Msg-id 20060801184725.GA18690@winnie.fuhr.org
Whole thread Raw
In response to prepare, execute & oids  (phazon <phazon.ml@gmail.com>)
Responses Re: prepare, execute & oids  (phazon <phazon.ml@gmail.com>)
List pgsql-general
On Tue, Aug 01, 2006 at 06:19:29PM +0200, phazon wrote:
> I juste want to get the OID of the line inserted. Does anyone know how to do
> it ?

It depends on the client interface.  What interface are you using?

OIDs are deprecated as row identifiers; the preferred method is to
use a sequence (serial column).  To get a sequence's value you can
use currval() or lastval() (the latter available in 8.1).

--
Michael Fuhr

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Can you run out of oids?
Next
From: Sundar Narayanaswamy
Date:
Subject: Re: Autovacuum help..