Jeff Willden <jeff(at)pavanell(dot)com> writes:
> When the primary key of a table defaults to the nextval() of a
> sequence, if you insert a new record into the table and accept the
> default, how do you then select the value that was just used as the
> new primary key and guarantee that you don't accidentally get the
> value that another user just generated at about the same instant?
currval() or INSERT RETURNING would do it. Check the archives for
a few thousand prior discussions ...
regards, tom lane