From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
Cc: | Philip Semanchuk <philip(at)americanefficient(dot)com>, PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: psql syntax for array of strings in a variable? |
Date: | 2021-10-29 18:05:24 |
Message-ID: | 714331.1635530724@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
"David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> writes:
> On Friday, October 29, 2021, Philip Semanchuk <philip(at)americanefficient(dot)com>
> wrote:
>> I would appreciate help with the syntax for querying an array of strings
>> declared as a psql variable. Here's an example.
>>
>> \set important_days ARRAY['monday', 'friday']
> Not sure why the single quotes are getting stripped out but that is the
> issue. Maybe double them up to escape them like in a normal text literal?
Yeah, that's just the way that \set works (and most other psql backslash
commands, I believe). You've likely got an issue with whitespace
disappearing, too, though that might be harmless in this specific example.
regression=# \set foo 'bar baz'
regression=# \echo :foo
bar baz
regression=# \set foo 'bar ''baz'
regression=# \echo :foo
bar 'baz
regression=# \set foo bar ''baz
regression=# \echo :foo
barbaz
Not sure offhand how well-documented this is.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Philip Semanchuk | 2021-10-29 18:44:15 | Re: psql syntax for array of strings in a variable? |
Previous Message | Pavel Stehule | 2021-10-29 17:52:30 | Re: psql syntax for array of strings in a variable? |