Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-interfaces by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group