Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column
From: Thomas Kellerer <shammat@xxxxxxx>
Date: Mon, 6 Feb 2023 18:43:52 +0100
In-reply-to: <DBAP191MB12892E942BD10BC2F46A354EB0DA9@DBAP191MB1289.EURP191.PROD.OUTLOOK.COM>
References: <DBAP191MB12892E942BD10BC2F46A354EB0DA9@DBAP191MB1289.EURP191.PROD.OUTLOOK.COM>
Ui-outboundreport: notjunk:1;M01:P0:3YG35TQ6CmY=;VXZUXY/d4XgTK/V7FNgU1EznEJ+ I73TOO9cuNbCOgABNxYEXJI7/O31bOzDS4DiHtU7PVMVahnaWHwRLTp5MoVkxh7Gmo9DbYtRP swlLACtWphGRVwYhnO6SstB6UdjEXUxOuBqIh6B9sQItzrjVIKIe42jLqg7t6/Uccvm+e1EYd fR4/BuIZBElFysThCDkPZISZsjMiNEkwfdpmh7V7l/nYFnrMK5fjVX7va2ayaBWFbObVjOPMz AZhWh1nyFI5L3ZCB8HROtgrqmQmLbNNzyT7F1nUluGK+kLy008WthJWR1tLCYwIrMa6FsaC6m MPQCfzOL3uw7XkFl/fp3D6YqV5aB4h2+u3zfv0Buz0FbD42hHKllhq2GpC//aoHou7F5hkUFy P7w2Joe6+PZbkXpenpIQEGhUU/BA9AB1ftVRBZFv/FyOsPr7Qxprgeb/if0za2vGaRC9tSHhK 6sejMDyE+XnWX7Y+o7cA+MG/x2/JAO7YiCSzj7TWTRaLHVZQN6rIQrl2N8Pwb2kMXBXVpN1Z9 4wWXp0wYXN3zNwPaz/c7igJ7u4BPnEOtY5fprA1825ZRjVQlod2o2LnfSGNONE+C4Wrkyd9/z L1LGCnQnuX59PfiSD6/TuDmvX0tKcqqfhbgg7t40Mp6kUuHEawSmSUi5gCCZaQBgbGVCS7NYj GzwQnkAvLdU0/1rvMl+HsoaDkIv/vZqEQ8dv1LM+FP61qC9XvAsUR5LNle+8TN9jD1KmG7nnl oODs3yZO2lzvAkx79hClNifBwLYQ3l4CLZD6Wps8CFghFPp5D2qUA+UBWKjDP2JMwuJuW7CWw AC3W5R4RI8bqSH1hGDAnDqmrpwX3cZ4BN5qAT+QbOFsAkQeVmLhGmzeqy5lSgRsbZBhmW/YPw OsEyg0Mtfh/lWb4hr6xPwp2Mx9D71H1urSw3gxN0o5W8jgW6ovDo1WJeCSlGKZUfcLaMWrlIQ lAA4Ng==
User-agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.21) Gecko/20090302 Thunderbird/2.0.0.21 Mnenhy/0.7.5.666

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column
  - From: Sebastien Flaesch

References:
- Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column
  - From: Sebastien Flaesch

Prev by Date: Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column
Next by Date: plpgsql: ambiguous column reference in ON CONFLICT clause
Previous by thread: Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column
Next by thread: Re: Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Postgresql & PHP] [Yosemite]