sequence value of the record just inserted. - Mailing list pgsql-admin

Dear admins,

I have a table whose primary key is a record_id with serial type.

I would like to know, when I insert a new row, what was the value of the
record_id that I just inserted. Since this is a multi user application, I
cannot simply select max of the record_id or currval of the sequence.

I would appreciate an advice.

Regards,
Ben Kim