Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column
Sebastien Flaesch <sebastien.flaesch@4js.com>
From: Sebastien Flaesch <sebastien.flaesch@4js.com>
To: pgsql-general <pgsql-general@lists.postgresql.org>
Date: 2023-02-06T17:17:17Z
Lists: pgsql-general
Hello!
Assuming that a sequence is used to implement GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY
Is there any built-in function that returns the underlying sequence name used for such column?
Otherwise, an SQL query to return the sequence name?
I need the sequence name, in order to reset it (setval) or to get the last generated value (currval) ...
The query must work with all PostgreSQL versions 10 to 15 ...
Seb