Re: [BUGS] BUG #14812: URI options cann't set with equal char. - Mailing list pgsql-bugs

It's OK, Thanks，I think our document can add this note in it.   




At 2017-09-12 22:49:03, "Oleksandr Shulgin" <oleksandr.shulgin@zalando.de> wrote:

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