Efficient Insert statement for one record into multiple tables?

Hello,

I have this task that I need to insert one user record into to tables A and B.

User table A contains primary key and main data. Table B contains extra data for

statistics. Table A has one field Id which is a sequence so it gets a unique value

for each new insert. I would like to insert this value into the other table B as well as

foreign key.

So I’d like to do something like this

insert into A (user_name, value2 ) values ( “foo”, “foo2”)

AND

insert into B ( id_from_a , statistic_data) values ( 23, “bla”)

How is this done the best way? I would like to do this in one call.

Sorry, for his dumb question but I’m not very experienced in Postgresql. :o(

Cheers,

Pete