Functions / Sequence Manipulation Functions

currval

Returns the value most recently obtained by nextval for this sequence in the current session.

Reading PG 18current·documented in 26 of 27 versions, 7.2 to 20

7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Signatures & examples

currval ( regclass ) → bigint

Returns the value most recently obtained by nextval for this sequence in the current session. (An error is reported if nextval has never been called for this sequence in this session.) Because this is returning a session-local value, it gives a predictable answer whether or not other sessions have executed nextval since the current session did.

Version history 3

12 → 13 changed
8.0 → 8.1 changed
7.1 → 7.2 added

Definition snapshot: b7bd9cda · English manual source