Minor correction: You call nextval in PostgreSQL to increment a sequence and get the number. curval is for getting the last value returned by a nextval call wit

Minor correction: You call nextval in PostgreSQL to increment a sequence and get the number. curval is for getting the last value returned by a nextval call within the current transaction. Since PostgreSQL implemented RETURNING for INSERTs and UPDATEs curval has become more of a utility function for use with psql and similar clients.