Re: Variable substitution in psql backtick expansion

Поиск
Список
Период
Сортировка
От Corey Huinker
Тема Re: Variable substitution in psql backtick expansion
Дата
Msg-id CADkLM=dVh_VD1GeyWjFCJxZsiAwW4aka7e2JxpDCsQY=vic2Zw@mail.gmail.com
обсуждение исходный текст
Ответ на Variable substitution in psql backtick expansion  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Дерево обсуждения

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 по дате отправления:

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: TPC-H Q20 from 1 hour to 19 hours!
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Patch: Write Amplification Reduction Method (WARM)