currval()

Return the current value of the sequence. Note that nextval must be called at least once prior to calling currval.

Arguments & returns

Scalar

Overload link	`'sequence_name'`	Returns
#01	`VARCHAR`	`BIGINT`

CREATE OR REPLACE SEQUENCE example_sequence START 1;
SELECT nextval('example_sequence');
SELECT currval('example_sequence') AS current_id;

Haybarn WASM 1.5.5-rc3 · In your browser

Guide example · Run to view results.

SELECT
  currval('my_sequence_name');