Postgres Pro
Downloads
Home   >   mailing lists

Re: Variable substitution in psql backtick expansion - Mailing list pgsql-hackers

From Corey Huinker
Subject Re: Variable substitution in psql backtick expansion
Date
Msg-id CADkLM=dVh_VD1GeyWjFCJxZsiAwW4aka7e2JxpDCsQY=vic2Zw@mail.gmail.com
Whole thread Raw
In response to Variable substitution in psql backtick expansion  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view

On Thu, Mar 30, 2017 at 1:33 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
single-quoted according to Unix shell conventions.  (So the
processing would be a bit different from what it is for the
same notation in SQL contexts.)

+1
Having been bit by format '%L' prepending an 'E' to any string that happens to have a backslash in it, I'm in favor of this difference.

Any reason we wouldn't do :"VARIABLE" as well? People might expect it given its use elsewhere, and it would make possible things like

SELECT '$HOME/lamentable application name dir/bin/myprog' as myprog \gset
`:"myprog" arg1 arg2`

both for expanding $HOME and keeping the lamentable dir path as one arg.

pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: TPC-H Q20 from 1 hour to 19 hours!
Next
From: Simon Riggs
Date:
Subject: Re: Patch: Write Amplification Reduction Method (WARM)