Re: [BUGS] BUG #14812: URI options cann't set with equal char.

Поиск
Список
Период
Сортировка
От Oleksandr Shulgin
Тема Re: [BUGS] BUG #14812: URI options cann't set with equal char.
Дата
Msg-id CACACo5SHsDSAH_3m6ikOojha3iic12pf2u9qujG2M1Z40r6aug@mail.gmail.com
обсуждение исходный текст
Ответ на [BUGS] BUG #14812: URI options cann't set with equal char.  (digoal@126.com)
Ответы Re: [BUGS] BUG #14812: URI options cann't set with equal char.  (德哥 <digoal@126.com>)
Список pgsql-bugs
On Tue, Sep 12, 2017 at 3:37 PM, <digoal@126.com> wrote:
```
psql postgres://postgres@127.0.0.1:1921/postgres?options="-c TimeZone =
+10"

psql: extra key/value separator "=" in URI query parameter: "options"
```

but in document:

https://www.postgresql.org/docs/10/static/libpq-connect.html


options
Specifies command-line options to send to the server at connection start.
For example, setting this to -c geqo=off sets the session's value of the
geqo parameter to off. Spaces within this string are considered to separate
command-line arguments, unless escaped with a backslash (\); write \\ to
represent a literal backslash. For a detailed discussion of the available
options, consult Chapter 19.

In the same document, under "33.1.1.2. Connection URIs":

Percent-encoding may be used to include symbols with special meaning in any of the URI parts.

Have you tried to replace "=" with "%3D" (and " " with "%20")?

Regards,
--
Alex

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: [BUGS] BUG #14805: Issue with Duplicate entry
Следующее
От: "Wong, Yi Wen"
Дата:
Сообщение: Re: [BUGS] Old row version in hot chain become visible after a freeze