Postgres Pro
Downloads
Home   >   mailing lists

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

From Thomas Kellerer
Subject Re: Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column
Date
Msg-id d0102694-471a-08c2-faf7-27e0366cb834@gmx.net
Whole thread Raw
In response to Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column  (Sebastien Flaesch <sebastien.flaesch@4js.com>)
Responses Re: Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column  (Sebastien Flaesch <sebastien.flaesch@4js.com>)
List pgsql-general
Tree view 
Sebastien Flaesch schrieb am 06.02.2023 um 18:17:
> 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 ...

Despite its name pg_get_serial_sequence() also works for identity columns

pgsql-general by date:

Previous
From: Sebastien Flaesch
Date:
Subject: Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column
Next
From: Torsten Förtsch
Date:
Subject: plpgsql: ambiguous column reference in ON CONFLICT clause