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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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