On Friday, October 29, 2021, Philip Semanchuk <phi...@americanefficient.com> wrote:
> Hi, > 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? Otherwise consider just doing a comma delimited string and using string_to_array in the sql to turn it into an array at runtime. > \set important_days ARRAY['monday', > 'friday'] > Not with \set. You could write sql to output the text and then execute it using \gexec to store the column value in a variable. That too may be a solution to the missing single quotes. David J.
