Re: [GENERAL] using Oids to retrieve a row

From: Karl DeBisschop <kdebisschop(at)spaceheater(dot)infoplease(dot)com>
To: dave(at)aersoft(dot)ie
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] using Oids to retrieve a row
Date: 1999-03-26 16:32:37
Message-ID: 199903261632.LAA03496@skillet.infoplease.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Fabrice Scemama 1999-03-26 18:32:04 Re: info on people running postgre
Previous Message Ross J. Reedstrom 1999-03-26 15:52:04 Re: [GENERAL] Are postgreSQL views UPDATEable?