Re: [INTERFACES] Retrieve rows 1 by 1

From: Hannu Krosing <hannu(at)trust(dot)ee>
To: vikrant(at)neuronetin(dot)com
Cc: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] Retrieve rows 1 by 1
Date: 1999-03-10 08:00:25
Message-ID: 36E62699.4F515304@trust.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Oleg Broytmann 1999-03-10 08:42:06 Re: [GENERAL] the last row in a table
Previous Message Vikrant Rathore 1999-03-10 03:42:49 Retrieve rows 1 by 1