From: James Olin Oden <joden@lee.k12.nc.us>
To: vikrant@neuronetin.com
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Retrieve rows 1 by 1
Date: Wed, 10 Mar 1999 08:17:30 -0500
Message-ID: <36E670EA.749A3E26@lee.k12.nc.us> (raw)
References: <36E5EA38.F88061AF@chemquick.com>
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.
> Can any one give me a way to retrieve,chage or insert data after any
> row.
> Thanks in advance
> Vikrant
I am not familiar enough with libq to give you the specifics, but I think
the key is to realize that though you do not have primary key, every
object in a table has an oid (Object ID) that postgress assigns it that is
unique. So when you do a select be sure to include the oid field, and
then you can update that specific record easily by specifying that"
oid = ####
That is whatever number you pulled from the database with your select. As
for the specifics the various docs on the website I believe describe the
libq interface very well (I just have never used it so I don't remember
it) so that you can fill in the specifics for yourself.
...james
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: joden@lee.k12.nc.us, vikrant@neuronetin.com
Subject: Re: [INTERFACES] Retrieve rows 1 by 1
In-Reply-To: <36E670EA.749A3E26@lee.k12.nc.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox