Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column

[Sebastien Flaesch <sebastien.flaesch@xxxxxxx>]

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