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

From: 德哥 <digoal(at)126(dot)com>
To: "Oleksandr Shulgin" <oleksandr(dot)shulgin(at)zalando(dot)de>
Cc: "Pg Bugs" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #14812: URI options cann't set with equal char.
Date: 2017-09-13 08:11:49
Message-ID: b6523f.8ef1.15e7a4b4f7c.Coremail.digoal@126.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


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

--
公益是一辈子的事,I'm Digoal,Just Do It.

At 2017-09-12 22:49:03, "Oleksandr Shulgin" <oleksandr(dot)shulgin(at)zalando(dot)de> wrote:

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Lou Picciano 2017-09-13 12:46:37 Re: about pgcrypto, not support "des"
Previous Message gomer94 2017-09-13 07:55:59 BUG #14815: event trigger in extension