On Mon, 12 Apr 2021 at 04:50, PG Doc comments form <nore...@postgresql.org> wrote:
> The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/13/functions-sequence.html > Description: > > Please add Note, how to get the (global) last value: > SELECT last_value FROM sequence_name; > > https://dba.stackexchange.com/questions/3281/how-do-i-use-currval-in-postgresql-to-get-the-last-inserted-id The reason this is not added is that it is incorrect to use the sequence this way. How do you know which session incremented it, or if it has been incremented since the last use ? The correct way to use a sequence is to increment it and then use currval or the like Dave Cramer www.postgres.rocks