I have a need to enter values in to multiple tables in a database. These
need to be related together by the ID of the last item inserted in to
one of the tables.

I will be using the C API to insert the data in the tables.

One option is to construct the entire series of insert statements for
one call to the database, which I understand will create an implied
transaction. If I do that, how can I get the ID of the last inserted
object in the first table for use in the second?

The other option is to do the initial insert, obtain the last insert ID,
and convert this from the OID to the value by way of another query. The
problem with this is I am unable to do this as a single call. Can I
instead simply call Postgres to start the transaction, send several
statements, and finish the transaction, or will this not work using the
C API?

Thanks,

The Other Guy

The Other Guy wrote:
I found the answer in the example code. I can simply call PQexec with
"BEGIN" and go from there.

The Other Guy