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

On Tue, Sep 12, 2017 at 3:37 PM, <digoal(at)126(dot)com> wrote:

> ```
> psql postgres://postgres(at)127(dot)0(dot)0(dot)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