get sequence value of insert command - Mailing list pgsql-sql

hi

create sequence mysequence;

create table foo( id integer default nextval('mysequence'), bla text, wombat integer, foobar date, primary key(id)
);

insert into foo (wombat) values (88);

now how do i know the id of my newly inserted element? and
how can this be done in a completely concurrency safe way?


cya
erik