https://stackoverflow.com › questions › 68809678

If you want to get the current value, you may want to try SELECT * FROM my_list_id_seq and use the corresponding value from the last_value column: postgres=# CREATE SEQUENCE my_list_id_seq; CREATE SEQUENCE postgres=# CREATE TABLE IF NOT EXISTS my_list (id int PRIMARY KEY UNIQUE NOT NULL DEFAULT nextval('my_list_id_seq'), mycardno int); CREATE ...

https://stackoverflow.com › questions › 18232714

If you want to claim an ID and return it, you can use nextval(), which advances the sequence without inserting any data. Note that if this is a SERIAL column, you need to find the sequence's name based on the table and column name, as follows: Select nextval(pg_get_serial_sequence('my_table', 'id')) as new_id; There is no cast-iron ...

https://www.postgresql.org › docs › current › functions-sequence.html

Sets the sequence object's current value, and optionally its is_called flag. The two-parameter form sets the sequence's last_value field to the specified value and sets its is_called field to true, meaning that the next nextval will advance the sequence before returning a value.

https://stackoverflow.com › questions › 13393604

To answer your question literally, here's how to get the next value of a sequence without incrementing it: SELECT CASE WHEN is_called THEN last_value + 1 ELSE last_value END FROM sequence_name

https://postgresql-tutorial.com › postgresql-how-to-get-current-and-next-values-of-sequence

SELECT currval('my_sequence'); Next Value (nextval): To get the next value of a sequence and increment the sequence, you can use the nextval function. Here’s the syntax: SELECT nextval('sequence_name'); Again, replace 'sequence_name' with the name of the sequence you want to retrieve the next value for.Example: SELECT nextval('my_sequence');

https://database.guide › how-nextval-works-in-postgresql

In PostgreSQL, the nextval() function is used to advance sequence objects to their next value and return that value. We pass the name of the sequence when we call the function. This assumes that the sequence object exists.

https://www.postgresqltutorial.com › postgresql-tutorial › postgresql-sequences

To get the next value from the sequence, you use the nextval() function: SELECT nextval ( 'mysequence' ); Code language: SQL (Structured Query Language) ( sql ) If you execute the statement again, you will get the next value from the sequence:

https://docs.postgresql.fr › current › functions-sequence.html

Cette section décrit les fonctions pour opérer sur des objets séquence, aussi appelés des générateurs de séquence ou plus simplement séquences. Les objets séquence sont des tables spéciales à une ligne créées avec l'ordre CREATE SEQUENCE.

https://www.postgresql.org › docs › current › sql-altersequence.html

The optional clause RESTART [ WITH restart] changes the current value of the sequence. This is similar to calling the setval function with is_called = false: the specified value will be returned by the next call of nextval.

https://postgrespro.com › docs › postgresql › current › functions-sequence

The two-parameter form sets the sequence's last_value field to the specified value and sets its is_called field to true, meaning that the next nextval will advance the sequence before returning a value. The value that will be reported by currval is also set to the specified value.