Re: Combining metavariables and table names - Mailing list pgsql-general

From David G. Johnston
Subject Re: Combining metavariables and table names
Date
Msg-id CAKFQuwb9jdGH6-og4HFQv=AU7UH+V2AjoQy2y+xZ_Cjz1bx5FA@mail.gmail.com
Whole thread Raw
In response to Combining metavariables and table names  (H <agents@meddatainc.com>)
Responses Re: Combining metavariables and table names
Re: Combining metavariables and table names
List pgsql-general
On Sunday, December 28, 2025, H <agents@meddatainc.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.

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Combining metavariables and table names
Next
From: Tom Lane
Date:
Subject: Re: Combining metavariables and table names