Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vaQ0D-0088Dh-27 for pgsql-general@arkaria.postgresql.org; Tue, 30 Dec 2025 03:02:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vaQ0C-002A2b-1x for pgsql-general@arkaria.postgresql.org; Tue, 30 Dec 2025 03:02:29 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vaQ0C-002A2T-0n for pgsql-general@lists.postgresql.org; Tue, 30 Dec 2025 03:02:29 +0000 Received: from mout.perfora.net ([74.208.4.196]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vaQ0B-003HA2-0x for pgsql-general@lists.postgresql.org; Tue, 30 Dec 2025 03:02:28 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=meddatainc.com; s=s1-ionos; t=1767063745; x=1767668545; i=agents@meddatainc.com; bh=qCyCoga4++blWizFWX0/aZvuMVpCAFZBFVK/oV0DwH8=; h=X-UI-Sender-Class:Date:In-Reply-To:References:MIME-Version: Content-Type:Content-Transfer-Encoding:Subject:To:From:Message-ID: cc:content-transfer-encoding:content-type:date:from:message-id: mime-version:reply-to:subject:to; b=2mM3tE7JboPudqfcMloOZ+JsWP0x8w4ORQqnrmYBWrh0vnT0Ukr7FfOR4gfV6Ojy Ga4vZGMukJdMShBT9Iqh7NJQ5BiTHUqzrGs6//7mrPpDWt3dY8ZmX8sGhei91gaTx gUXl8y5kLcS1pwcfljM8gLdhKUkPRDWVPezXkDLEBinMAUc+ufTcSwe59odcI5BB1 1oAD/KXhfe0Jso9IIeCSet/NlXKTcVtfThGr3bQEuUpJ/+Yj5tIZpFjU/FDzj0pCQ vUBK2h9sinm1Iya2OLSTGQnrdXGZtMiJx7eIPpZOV8VYAL8N1gg2pqRBD31ugukez Hyi5ivYH8zNZ9GJOCg== X-UI-Sender-Class: 55c96926-9e95-11ee-ae09-1f7a4046a0f6 Received: from [192.168.147.52] ([166.170.34.239]) by mrelay.perfora.net (mreueus002 [74.208.5.2]) with ESMTPSA (Nemesis) id 0Me96G-1vH8Iw2gBS-00Y5QY for ; Tue, 30 Dec 2025 04:02:24 +0100 Date: Mon, 29 Dec 2025 22:02:20 -0500 User-Agent: K-9 Mail for Android In-Reply-To: References: <8254F175-871C-4678-8D28-A67E09B099A6@meddatainc.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Subject: Re: Combining metavariables and table names To: pgsql-general@lists.postgresql.org From: H Message-ID: <403D51E9-3428-452B-A01C-2B090C1F637F@meddatainc.com> X-Provags-ID: V03:K1:aMu5VRP13+sKB2WcZzTrwyqBDfAT+Wev2uiukj15RzxZ9Mpb1zu rRYMyJ21w6YahfSb3OiY7eUWZrkHMnCReQ48E3Jci6MBSHF2OfV9A1TRVouW57MoJ1he7oG +9iKjH8LEyR9XtQ0keqtwcsUcBhsIPQyeq28dHC7UTfSmbPqXZW8KhZxpfyi1rm+8kj8b22 babKDk6bFJVm8wrdyuY8w== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:3aL3oWM4dcQ=;nxi5ec3gwjiBYOLqqx0+ZlW/voA h4ibaef26/sSlYc2ltHfDX1nlTrSr98Inly1zr8ffx6V63kGnxhTDQirBMzeXC/7pUe1XD8iQ INAq7b5LL28wC8jv8v4IZTfmK5NFEY/LLiVSXbD1+lp/AhcL6669bvDVgTCFxBs5UliVzJziU wv/DpjTzn+IfNXvFOomB0fu3ypBCNebBy4iR4Iyb2St4cBWsRt2dg5EtVtHK0/HflHWSfuhi0 Nzi0dHwKoIm8DGdlvBF8WSmTKz5qcrhOz+rZTMzVvOVkIkdIV3oqHBt14L7aLZ+VfOnGld7em EE8yMdIZn2GRwtxc1bLYEEPXx0JIAYzFzkpoe4xXw9r9yWvv1vkZB2PqknUKBecJd2IeBG3WU Dd3MCWkuRxb8XrWVLPGteVaVNGO/EqbFAvEtvCR372rJ2IV18+inlz0pGMPrBPDTAgRVL/dde n6wiy0DUE1C7TJC5AGskMrRVYEH22IOucInJ9ahV9IKP+AwJruEMpK70XjaY98NL8Cm/7jVhI siRVIVEvLdEhkbtoq5Fd6Hxiu6/bAk9taUTtRfD6Szyz6lXUXk+QrXlmjf9a+RKVQM94Wow6J OG42mVbHCfgCIGGDwkk7TO908HFlDzhkv4g73u3Fv/ztjjOC8rJhfddkv4AsHMW8NAVaUKE2E 8W8GmnXQyHwsuVhJ3k8wpp7FblXsa71vHT+vOLZ1cOhQ3h52tlKDaNuXKGfeDu3bC4xgHPDPn yaexNN3/DQT5ZpWY/i9mdPJ4XnuWioqHCO7NZqnZMjAJY+r1I2N2XOxs04rGxa8u8fy2aHhQX EdDQf+qy7MtUp+G8TYeOxopGQ7mMReZrKGUQ7p0bWEajEMLSK1Lr6KbnqbhKjCOG48fvFDBuv bUk0iXirKqdv1lgHAcVzv6sXa4zbNOlj6zn81DaWAMYxfkM91IA/lYeo4XCYtKyXEHRpG8o0s 9buK55XHSjtIwoFEzXUUFxW5lZRmgcZOuHN3CjI7LJSS+Z9fdILLQcBAUsehUGtpZll0sqLts 4Q/M1PBP6Ae28uUWA8ozf2LQJmlk+cFdFlqEiPWPTzKh/YvKUMvQCt/BrNxNp2zBXl/rVmYC2 BsBSDqTidXXJF/P7Be2lvSTxG0+CJeJjyMVDpelWio2uD1b+W0zlWNnDkdD/Lc1oeVX8Yre8+ dtLKc8lQn/bZwG59KY2u2Z/rzS+IwiZBk/apfcOlVatT+2UHft73enYnc6pmPM1gEua85wV7d Y02/Uu6nar5s43EyFm+LhZ5Kvzd7911g1j6DdC4SEN1N8jHxEZQf5v0fCHZHuYmGiNM4PO9Ph 0OtqdUEk89PZoD1suBPnAR4JeN9grs6cUH4EkxieWuNZFRfDTGbmM3PXrnJr+PEwxhObbh6bW Y0W97KimrbBnjyinzCBDJJFVbhEtkRar9YVPI3kjnwXUIrD/k1K3q0OiIvuGTPe4uqhiKFaH2 yc91DUMyaU1Fnz7vL+GhULF7MgvBZlzDmMn99qTUwcg6JLjKDVkqWKIRhQ1UiLXCVijctcT8z h1hWdoXyyiAjOLJnMqiqbkIdgVujYjtC2SF6CRqb3n++hgYz6ocZ6lD42KEEMn4zlZ8SvuRBN W0gdMlEXoP0TCZzZNlN2odp9DsJ7WwQRf6/Ep7n3f/Kpz86ULPaEv89CAnlNjem6DZXR1kw40 lmNLGCdtQA6WIQjBw/s1XcwflVV8Qms0YucAlbElVmna59Uag76j3G/wrWoN7YjdWM87E6pKw KgDjX30sHnnD3 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On December 29, 2025 8:17:37 PM GMT-05:00, "David G=2E Johnston" wrote: >On Mon, Dec 29, 2025 at 5:58=E2=80=AFPM H wrote= : > >> Just tried your suggestion to use format() but it resulted in a >'syntax >> error at or near "("' >> > >Helps to show exactly what you tried=2E I provided pseudo-code=2E > >postgres=3D# \set sch 'schemaname' >postgres=3D# select format('%I=2E%I', :'sch', 'tblname'); > format >-------------------- > schemaname=2Etblname >(1 row) > >Admittedly, if the names do require quoting, and depending on how the >function uses the value, some additional tweaking may be required=2E > >There shouldn't be anything you cannot do with format that you can do >with >pre-processing and setting the variable up-front=2E Admittedly that is >probably cleaner overall anyway though=2E > >David J=2E I used the exact syntax you provided, however, I suspect that format() can= not be used in an argument in CREATE TRIGGER=2E