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

Last serial inserted

From: Eduardo <ekotuja(at)brasilnet(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Last serial inserted
Date: 2000-10-16 16:50:05
Message-ID: 00101614551200.00949@YOSEMITE (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
 How can I get the last id ( serial number ) inserted.
 My C code is :  

 res = PQexec(conn,"insert into table1 (field1) values ('value1')");

              id SERIAL,
              field1 VARCHAR(10) 

    Eduardo K

pgsql-novice by date

Next:From: mikegDate: 2000-10-17 03:01:28
Subject: performance hit with large tables...jdbc?
Previous:From: Tom LaneDate: 2000-10-16 15:44:30
Subject: Re: Re[2]: SETOF modifier

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