[SQL] Last serial number inserted

[Eduardo]

 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