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

On Mon, Oct 19, 2020 at 1:13 PM PG Doc comments form <noreply@postgresql.org> wrote:

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/13/functions-sequence.html
Description:

This page:
https://www.postgresql.org/docs/current/functions-sequence.html
doesn't seem to mention that there's a way to get the "cross session"
current value of a sequence:
https://stackoverflow.com/a/12482716/32453

That page says "sequences are single row tables" which means you can query them, it also links to CREATE SEQUENCE where "SELECT * FROM sequence_name" is described explicitly, plus there is the implied existence of catalog entries.  That seems sufficient given that such usage is not all that useful and so less is more when it comes to pointing it out to users who should just stick to the provided functions.

David J.