On Monday 19 June 2006 13:40, Corey wrote:
<snip>
> I'm using the perl dbi interface to postgres, and I'm wondering how
> people do the following:
>
> insert a row into a table, and then immediately get back the pkey/id
> of the row, so that I can then use this id to insert into another related
> table.
>
Ok, so of course, a few more minutes of searching/reading/googling,
and I found the answer to my own question:
currval()/nextval()
Sorry for the noise!
Cheers,
Corey