Re: Combining metavariables and table names

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: H <agents(at)meddatainc(dot)com>
Cc: PostgreSQL Users Mailing List <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Combining metavariables and table names
Date: 2025-12-29 01:53:50
Message-ID: CAKFQuwb9jdGH6-og4HFQv=AU7UH+V2AjoQy2y+xZ_Cjz1bx5FA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sunday, December 28, 2025, H <agents(at)meddatainc(dot)com> wrote:

>
> I have a feeling I might be missing how to use the combination of a
> metavariable and a table name when used in an argument to a procedure.

No, what you are doing is impossible if you limit yourself to direct SQL
command syntax writing.

> Even though I gotten it to work, what would the correct usage be?
>

I’d probably do something like:

versioning(…, format(‘%I.%I’, :’s’, ‘test_history’), …)

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2025-12-29 03:41:19 Re: Combining metavariables and table names
Previous Message Ron Johnson 2025-12-29 01:48:22 Re: Combining metavariables and table names