Re: [INTERFACES] Retrieve rows 1 by 1 - Mailing list pgsql-interfaces

From Hannu Krosing
Subject Re: [INTERFACES] Retrieve rows 1 by 1
Date
Msg-id 36E62699.4F515304@trust.ee
Whole thread Raw
In response to Retrieve rows 1 by 1  (Vikrant Rathore <vikrant@chemquick.com>)
List pgsql-interfaces
Vikrant Rathore wrote:
>
> Please any one can tell me how to update,insert or change a single row
> using libpq interface. The table is not indexed and do not have a
> primary key.

each row has an unique 'object identifier' field called oid (that is
returned by a single-row insert if you use the psql interface)

so you can use where oid=NNNNN as qualification

Hannu

pgsql-interfaces by date:

Previous
From: Michael Meskes
Date:
Subject: Re: [INTERFACES] the last row in a table
Next
From: James Olin Oden
Date:
Subject: Re: [INTERFACES] Retrieve rows 1 by 1