Re: Directly embedding a psql SET variable inside another string?

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Adam Scott <adam(dot)c(dot)scott(at)gmail(dot)com>
Cc: Ron <ronljohnsonjr(at)gmail(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Directly embedding a psql SET variable inside another string?
Date: 2023-01-13 17:14:45
Message-ID: CAKFQuwYNRU3J9EbZD8dyxt0aJ_CPnsdLMhv89Wj5O6joO4Ujqw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Please don't top-post.

On Fri, Jan 13, 2023 at 10:08 AM Adam Scott <adam(dot)c(dot)scott(at)gmail(dot)com> wrote:

> Do you mean like this?
>
> postgres=# \set v_embed %:v_ssn%
> postgres=# \echo :v_embed
>

> test=# \set v_like %:v_ssn%
>> test=# \echo :v_like
>>
>>
Aside from the names those look identical...

David J.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2023-01-13 18:07:25 Re: Directly embedding a psql SET variable inside another string?
Previous Message Adrian Klaver 2023-01-13 17:13:59 Re: Directly embedding a psql SET variable inside another string?