Re: [GENERAL] returning oid of last insert?

> Thanks for the help. I checked libpq, and just to follow up, it is quite
> easy to get the oid of the last insert using the routine oidStatus.
>
> On Sun, 19 Jul 1998, Peter T Mount wrote:
>
> > On Sat, 18 Jul 1998, Matt McClure wrote:
> >
> > > Is there a way to return the oid of the last insert command?
> >
> > The protocol does return the oid, as a string. You can see this when using
> > psql. I'm not sure what libpq function returns this value though.
> >
> > In JDBC, there isn't an official way, but the 6.4 driver does have a
> > method to retrieve the oid (It's used internally with the new object
> > serialization code). Earler versions store the string, but don't use it,
> > and have no method to retrieve it.

I have added this to the TODO list:

* add a function to return the last inserted oid, for use in psql scripts

We need it for psql scripts. Things using libpq directly already have
access to this information.

--
Bruce Momjian | 830 Blythe Avenue
maillist(at)candle(dot)pha(dot)pa(dot)us | Drexel Hill, Pennsylvania 19026
+ If your life is a hard drive, | (610) 353-9879(w)
+ Christ can be your backup. | (610) 853-3000(h)