Postgres Pro
Downloads
Home   >   mailing lists

Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column - Mailing list pgsql-general

From Sebastien Flaesch
Subject Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column
Date
Msg-id DBAP191MB12892E942BD10BC2F46A354EB0DA9@DBAP191MB1289.EURP191.PROD.OUTLOOK.COM
Whole thread Raw
Responses Re: Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column  (Thomas Kellerer <shammat@gmx.net>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Philip Semanchuk
Date:
Subject: ALTER COLUMN to change GENERATED ALWAYS AS expression?
Next
From: Thomas Kellerer
Date:
Subject: Re: Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column