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 or flat)
Thread:
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')");


table1:     
              id SERIAL,
              field1 VARCHAR(10) 


Thanks
    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-2014 The PostgreSQL Global Development Group