Re: Combining metavariables and table names

On December 29, 2025 8:17:37 PM GMT-05:00, "David G. Johnston" <david.g.johnston@gmail.com> wrote:
>On Mon, Dec 29, 2025 at 5:58 PM H <agents@meddatainc.com> 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.  I provided pseudo-code.
>
>postgres=# \set sch 'schemaname'
>postgres=# select format('%I.%I', :'sch', 'tblname');
>       format
>--------------------
> schemaname.tblname
>(1 row)
>
>Admittedly, if the names do require quoting, and depending on how the
>function uses the value, some additional tweaking may be required.
>
>There shouldn't be anything you cannot do with format that you can do
>with
>pre-processing and setting the variable up-front.  Admittedly that is
>probably cleaner overall anyway though.
>
>David J.

I used the exact syntax you provided, however, I suspect that format() cannot be used in an argument in CREATE TRIGGER.