Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pPk3x-0002fY-8d for pgsql-general@arkaria.postgresql.org; Wed, 08 Feb 2023 13:00:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pPk3w-0004lf-0p for pgsql-general@arkaria.postgresql.org; Wed, 08 Feb 2023 13:00:36 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pPk3v-0004lV-FQ for pgsql-general@lists.postgresql.org; Wed, 08 Feb 2023 13:00:35 +0000 Received: from mx0c-001a4c01.pphosted.com ([67.231.158.153]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pPk3r-00071s-37 for pgsql-general@lists.postgresql.org; Wed, 08 Feb 2023 13:00:34 +0000 Received: from pps.filterd (m0210019.ppops.net [127.0.0.1]) by mx0c-001a4c01.pphosted.com (8.17.1.19/8.17.1.19) with ESMTP id 317KxOFa004254; Wed, 8 Feb 2023 08:00:26 -0500 Received: from eur05-db8-obe.outbound.protection.outlook.com (mail-db8eur05lp2104.outbound.protection.outlook.com [104.47.17.104]) by mx0c-001a4c01.pphosted.com (PPS) with ESMTPS id 3nhm6vb5jd-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT); Wed, 08 Feb 2023 08:00:26 -0500 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=Rk+SgwljHYO/vY53mM4H+QsGPzm8FU/gLbEkF3eEnXEKs1p+BXKJEqChfzMyAJNTI+8tCUafuO8QrMMtyYyFn0VH/xDs1uLfyba/XgPUR5ub46qB0e94LL5qcMLkvoAe+DtQISiBJgjZA1L9O/4Bghg7dxIhD2z6i4inNLr+Ai5MZsxMoPfjJKP+9J23XXrm+URhYxbsHtRfo9Da423c5T7mh4dqz7+eEkLRAEyRXdlhuEDgJDC0CUfRmqyFEfaNzT8Bm44B2/ZOkrZtCB8Sf3qTkbDejju4TK64RfrfxI/2Gl3bPrT6cSAGqCX1N5I96R1Co/k1kTqk5Nvpgt1/iw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=NGCXWftNAaAsharndFJG52Gci/2xbK/IEY2YAyOaH+A=; b=GV7pqAwlLzbP1cAaPbKHafOZgP52MEMoJJXxWdaAPMZGPnglQDaKISc9cm79MaNidtSzyysQe4rihuoF+Mj4nPGjI95lXpZDLlM8LzKkr7p8EljtOvIUtzgqqQ34M+Wi2UG8sjueDh8L+oV4Fwh875pcvg6co25EPkkdKh3uXk1dmaK7sdAqyZlB4vVpoHt7SzPZ6dEZ6+i/qUW6ubp/D9cM+nFneh8fUTGNEwcgRK3pLKAMq0qIodInyvwVgrWGm3s/m0UrV+zJiIxBoQ8vH+yTUqqLNZ1zZ/75o7XYlrSuN/+1/0QLFXykOVkuSSULTuM6TwOimphrgngu3YL+8Q== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=4js.com; dmarc=pass action=none header.from=4js.com; dkim=pass header.d=4js.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ourvolaris.onmicrosoft.com; s=selector2-ourvolaris-onmicrosoft-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=NGCXWftNAaAsharndFJG52Gci/2xbK/IEY2YAyOaH+A=; b=SjCk7igj2xbJg5Bb+k8V0ujwaOofQ87AeQ5dG6xwrlbZPtRwRmbrwj5okcZ/pCbwjjEFf0W+f2vVsH8XByGMKYLzMdAy13CxYYNAQVTEKG/DsKizKGuzMqTNql8dJIXhub9jER8H84Px8z8eG5E/+dqSZXWZRiinytWlDt9mbcA= Received: from DBAP191MB1289.EURP191.PROD.OUTLOOK.COM (2603:10a6:10:1c9::19) by GV1P191MB2218.EURP191.PROD.OUTLOOK.COM (2603:10a6:150:9d::16) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.6064.32; Wed, 8 Feb 2023 13:00:22 +0000 Received: from DBAP191MB1289.EURP191.PROD.OUTLOOK.COM ([fe80::1a8d:b5bc:c2a4:1e48]) by DBAP191MB1289.EURP191.PROD.OUTLOOK.COM ([fe80::1a8d:b5bc:c2a4:1e48%8]) with mapi id 15.20.6086.017; Wed, 8 Feb 2023 13:00:21 +0000 From: Sebastien Flaesch To: Peter Eisentraut , "pgsql-general@lists.postgresql.org" Subject: Re: Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column Thread-Topic: Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column Thread-Index: AQHZOk3x4kbB9OrqUU+Fiv52aA7c8K7CMIsAgAADIYKAAAOo64ABEAEdgAGfJgCAAB90dQ== Date: Wed, 8 Feb 2023 13:00:21 +0000 Message-ID: References: <10d743ad-2216-df5b-a966-38f154a6f53a@enterprisedb.com> In-Reply-To: <10d743ad-2216-df5b-a966-38f154a6f53a@enterprisedb.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: x-ms-publictraffictype: Email x-ms-traffictypediagnostic: DBAP191MB1289:EE_|GV1P191MB2218:EE_ x-ms-office365-filtering-correlation-id: 30cdafe3-f978-4c3b-a908-08db09d46fee x-volarisppoutbound: true x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: 0qpZ8IIiu8DgN2YkRqh+8649Pfj3eMG+mAnkHNlXy7nOfDusygOuk8rsNfEn88OfcmPFfmkFVpOO2o5kPfPtEx/RcAEVW+72zb2E4N4fHH0Jb0wgqR8jRiteMGKkmeIr9vk4Q88KQfnP1VCbAy0pwfyiXhgdEbprkJwCc6hbNNZZ5nvtMV4KaIM7cSJaGzjgn+46ZCShdBGN6v6cOAztOyJItMsirDP1AcBA92nteUWCZ7yT+0r4nWxxjqHN8UxjFNtA/yqwnKo+UPpdRrG5onwG6xEREhKA5nQUHqx4dxa1aW4okSq6L2yCIjn/aLIJgqn+mAhM3iiKFwHthiP5dveAb4NRST7SBpqcmVvCerBtJSme/5uTBMS95PYBJY6s1ycpgROzESXzxUmFn91dXvQ9uw7Fyq/yFNACXkgCwgdO+sAF3D6xMHqwMSYd8t0QKv4VObL5RSvoNtjCGeHt34RaYo2cnCdfCbJE46GST21MG+2MOaFKkpCB/TgglAK9+i5ic3i5fnXhbcH4PZtvYAGazFqWGoJryJjD8O7kleyrcfLbZbYMafDuQzFXReaxl1V033UQNv8/0cqPv7zswvcGbKGVrTdLPTGT55D1lQFmtt3qC36JnW0F1Ah7k91jQLTkrqtnqxxAgeKcqvlk2BN5rpyTCFjO4G8ImomGHGEV6g/weZin5+I5Jc8Il+HTSUKpygu0kU1w+nt9ERY2iqhzcG8ZZCFEYX0ZPCpKsuc= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:DBAP191MB1289.EURP191.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(13230025)(4636009)(346002)(136003)(376002)(396003)(366004)(39860400002)(451199018)(19627405001)(83380400001)(44832011)(4744005)(5660300002)(2906002)(186003)(71200400001)(9686003)(26005)(6506007)(53546011)(33656002)(64756008)(52536014)(8936002)(66556008)(41300700001)(66446008)(478600001)(7696005)(86362001)(316002)(38100700002)(76116006)(55016003)(38070700005)(110136005)(66946007)(66476007)(91956017)(8676002)(122000001)(15583001);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?us-ascii?Q?jyRGYSSedw8R1hFfZ9R3XqirZygVYa4RqK+w4U/rz19CE1YGVuovwXtA2cGb?= =?us-ascii?Q?VU3KvVjdt30h+iUaWfq5T18NXjnSao58C5DprfPNmiMllH0heQOtnX77i4fb?= =?us-ascii?Q?knE6xUI5wakb7voOytKo7yINRdFNo3milSVJXEOBpF3RwExX/zqkaabHyTSc?= =?us-ascii?Q?VtdY2opZN1WNQs5Zm8TUgB3bJjxPrzn/ojcwyLWoIjqkNOT03JOxnheapxbH?= =?us-ascii?Q?5xUJSOqUQ+72ku7+RDyGeL4WRozJwm6JLSVRN1A2OKfjLsj75hijsBAVnpQD?= =?us-ascii?Q?pBkg20I/4gljWoGoTchshwZnGdSgcoAfkdWomIbNIev8aJeIcbpyG5lPDntm?= =?us-ascii?Q?SsYherAwfd/3aJWW+xd6OvCmGy+HDqJTSfw5tVtRTh4Zt6w01blzYKZLI8eU?= =?us-ascii?Q?Cd9cU0Ue1F6fHXeVEeqJetBJwx3LPUxXGqVWf+EAt5GwuwVZzP15N8peasyq?= =?us-ascii?Q?/Rrnpq8VGy1wjb+R0XPrzbpxNKqr3nuRqBbMhjJm75PMdHXYXBW/ipi2pbAS?= =?us-ascii?Q?OgzZqTMB8lUw1/9zPcopmzoXeEUpfXUI7Zp7KXX7CfUUwRumGyhlBgNG6ttG?= =?us-ascii?Q?/ONjtOU0OyMAd0ZJzWOrLh0/nQP6wJJ77fir3pV6Bbm1qoKR76VOwRfprc7r?= =?us-ascii?Q?9fGn0KRnGlmRZnv0BgNLQLkwoErfoGvuuWr25IqSLUlnyF7DanMgYP9bWI2Z?= =?us-ascii?Q?hdr2ZzSRgdV46vQRySWi0DP/qT/QSThfxZS3ejz6pQvwZxZDTGQ9kJd9XtgK?= =?us-ascii?Q?aHI7SMi4c265Sd3PFaZDLea9H/9s3hnIjmSqX31aDxv4a4qGyr5PQ6dq2wVv?= =?us-ascii?Q?z11ARUMjwuMGtMdw+Z7MAs8Jj6ZF/PN7TkXW8K1TA8xCDzW/P3wS5XaLRQck?= =?us-ascii?Q?kuq5rypf1xMwHenBZIFqREWJll6JO+OQjixLocjEuMp+H7iS9Cgph/cutBgu?= =?us-ascii?Q?wP5SBP/StOy4JYRDVgiD6c6jcpjjYfmox2HL2HPXakCuLGQHNPYQuVoG9KkQ?= =?us-ascii?Q?TNJ5kwLm2Sl2q9eUwel2P2tbLujqeO4oBIl6Xpa7+uISMV/5mtyFmnYiIbz8?= =?us-ascii?Q?WG53jKb19vo36anx3eDe728uIV4TEDJgDpxry8ineQ+mt6+KfVvPnKTxeWw9?= =?us-ascii?Q?8w1+nzpsk+STovpuDXRnAjEyM47ZrL8oQGk/CIeiGoFsRdaw+KLbb1dwVLFN?= =?us-ascii?Q?J+OXJ84NVczU+XNq8feW1+PcCQ9WvZeelbKSOFPSeGbqbHfSFnDweV9h5Sr4?= =?us-ascii?Q?BR5wyv67A9Min+MzEeOpxaTxm9FViw9Nv/lClQYPvV0VzyJZ5bcpyQlhA6Qh?= =?us-ascii?Q?t/fjSLMBAWdgYzID6nNmYNkuJgm2qWRU2RSOCV9F195v0fc60/z69BP9C/mn?= =?us-ascii?Q?qv6K3eZIV0+5+4EzLP+iHzkwXfyS1yiSC60hzGrIT+QU5EKsWCBfhAK6EGTC?= =?us-ascii?Q?u+PuSu/BLSEcteZdpivUe3IfA5i0AYWI/yMjDxq0ms5mr+G8aUPrsG3NhisU?= =?us-ascii?Q?vqiUpbU9cLaCRYmgKAPXEYwROBQbXQTmTVOiEwQtiFg0RzVDfaZKPlJhlUA/?= =?us-ascii?Q?Y4PntQLF/QnH2IcAAr5Cl7RcFcFeQbgsrxsyZ7E1?= Content-Type: multipart/alternative; boundary="_000_DBAP191MB1289C9AE83CB97AFE54B9DC3B0D89DBAP191MB1289EURP_" MIME-Version: 1.0 X-MS-Exchange-AntiSpam-ExternalHop-MessageData-ChunkCount: 1 X-MS-Exchange-AntiSpam-ExternalHop-MessageData-0: jzRxtaQpzZ4UYWYRy2NtSTLUqQh7V+xvakycmPVePqFOIMCX/r5vSzJaOsb/zR55od697Qjtd8kNLCbWiZ2o8BCDGWN4h+EuVsr+NvH0hqL53DI0W4t/aSXpLpzSCe/l4ADoTSrsSevHcCvp8mskycfH2Vr6BNZAyOUp5qeEamY2+9JO1yliYjH8GcTi0xW9RxklqM+PdBoEC8L0wHOCnG82kwuyPjFH4KEewPK4k+bdG/nehp9cJvGMLdSzwemi+mFGU/YNtlp56FSeYjfOqC9nnlbjDAsGaE17hcuqYkxyvxoTXhkkUdFFKCWYI9uZfZIKUvVgBsIX+p00kOSGeW9T4RSBmKW0pEEFSUm6WaVbr172f+305v6Qdlfh2L/Km8Nd/IFY6q+8AfIcxIBcK31TLoQ/xdAYKDcKyXM+CtJA5oF9z2qalDVsbb+vGrFAUZ+l/P2PD5hatAldCvpZQyI879HD862nHTvNAKaLeA5t7slze5wNmVoofld+BCEb2bQ834EBlkUDUNHd7b7yvuHQNIdZt8AN0uM7ZSw+GoE252DJEuzja5smuILHFgAfg3JW6V9Wk5veQO5b8O+ckO+aISeRFGMQXdq76C0NSeEsi3rr7F8lPw2GJeSynoDvjAB4LBHeXlfOqtc2FNvrV7dIKQur6HXQir1XRM+Le9fMT2thPreAwlbw29A3SXDctH8tSIoOQ3wl/YGAKnkornOgd24o20+otCQyTgqTDEN5L9umXt88QHnlFU4ieVGbm4074tP4wLpMF3vqM0qWNRH0ugBQ8cI2RK5UZMWpJSx1/aLg3oZGuPCc5dHhdshiFVQj1gN8p8GMQT964tD/5h85tkIbNm0G8bNgEoBktO4= X-OriginatorOrg: 4js.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: DBAP191MB1289.EURP191.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-Network-Message-Id: 30cdafe3-f978-4c3b-a908-08db09d46fee X-MS-Exchange-CrossTenant-originalarrivaltime: 08 Feb 2023 13:00:21.8060 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 75c696ec-5bfb-4892-9a0c-9187a9061cd6 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: 2YQo701+jGsTuJOiRYgy+eZ5Npm/KIEU3RblLkkSaLdFkHTupdXHabs3uzgG9+N5pNVQuFFIapt3YUpOJm3E6KiHnm1eF6T6l0r5qU7zKhQ= X-MS-Exchange-Transport-CrossTenantHeadersStamped: GV1P191MB2218 X-Proofpoint-GUID: 8sTGZ2g_-ocnWDZ3Gx0M29cevfXCgPM1 X-Proofpoint-ORIG-GUID: 8sTGZ2g_-ocnWDZ3Gx0M29cevfXCgPM1 X-ProofpointHeader: Yes X-Proofpoint-Spam-Details: rule=outbound_notspam policy=outbound score=0 clxscore=1011 bulkscore=0 mlxlogscore=999 suspectscore=0 spamscore=0 malwarescore=0 lowpriorityscore=0 priorityscore=1501 mlxscore=0 phishscore=0 adultscore=0 impostorscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.12.0-2212070000 definitions=main-2302080116 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_DBAP191MB1289C9AE83CB97AFE54B9DC3B0D89DBAP191MB1289EURP_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Good point, thanks Peter! Seb ________________________________ From: Peter Eisentraut Sent: Wednesday, February 8, 2023 12:07 PM To: Sebastien Flaesch ; pgsql-general@lists.post= gresql.org Subject: Re: Get the sequence name corresponding to a GENERATED { ALWAYS | = BY DEFAULT } AS IDENTITY column EXTERNAL: Do not click links or open attachments if you do not recognize th= e sender. On 07.02.23 11:43, Sebastien Flaesch wrote: > select '"'||ns.nspname||'"."'||p.relname||'"' tabname, c.attname colname Just a side note: You might find the quote_ident() function useful. --_000_DBAP191MB1289C9AE83CB97AFE54B9DC3B0D89DBAP191MB1289EURP_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
Good point, thanks Peter!
Seb

From: Peter Eisentraut <= peter.eisentraut@enterprisedb.com>
Sent: Wednesday, February 8, 2023 12:07 PM
To: Sebastien Flaesch <sebastien.flaesch@4js.com>; pgsql-gener= al@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: Get the sequence name corresponding to a GENERATED { AL= WAYS | BY DEFAULT } AS IDENTITY column
 
EXTERNAL: Do not click links or open attachments i= f you do not recognize the sender.

On 07.02.23 11:43, Sebastien Flaesch wrote:
> select '"'||ns.nspname||'"."'||p.relname||'"' tabn= ame, c.attname colname

Just a side note: You might find the quote_ident() function useful.

--_000_DBAP191MB1289C9AE83CB97AFE54B9DC3B0D89DBAP191MB1289EURP_--