Re: [GENERAL] using Oids to retrieve a row

[Karl DeBisschop]

are you doing this in psql?

Or perl, php, or some other?

perl and php both have methods for getting the oid of the last
inserted row (use "$oid = $sth->{'pg_oid_status'};"
 in perl and "$oid = pg_GetLastOid($result_id);" in php )
Look at the php documentation, or do 'perldoc DBD::Pg'
to see more details.

I think the postgres documentation for PL/Tcl also
has a quick and simple way of doing what you want, but I can't seem to
find it now so I'm not sure about that.

Karl