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

Reply via email to