Last serial number inserted

From: Eduardo <eduardo(at)complex(dot)com(dot)br>
To: pgsql-sql(at)postgresql(dot)org
Subject: Last serial number inserted
Date: 2000-10-17 10:16:58
Message-ID: 00101708182600.00842@YOSEMITE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2000-10-17 15:47:18 Re: Last serial number inserted
Previous Message Indraneel Majumdar 2000-10-17 05:19:43 Re: Antw: many-many mapping between unique tables