Thread: specifying multiple options in URI psql behaviour?
Hello, can anyone confirm this?: * connections with at most 1 option after the ?-mark sign work: like #psql postgresql://myuser@myserver/mydb?connect_timeout=10 or #psql postgresql://myuser@myserver/mydb?target_session_attrs=any * but if you put more than 1 option, then it doesn't?: #psql postgresql://myuser@myserver/mydb?connect_timeout=10&target_session_att rs=any -- https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-CONNSTRING-URIS https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-PARAMKEYWORDS mvg, Wim
Wim Bertels <wim.bertels@ucll.be> writes:
> * but if you put more than 1 option, then it doesn't?:
> #psql postgresql://myuser@myserver/mydb?connect_timeout=10&target_session_attrs=any
Maybe you forgot to quote that? Ampersand is a shell metacharacter.
(It does seem to work for me, as long as I put quotes around the URL.)
regards, tom lane
Tom Lane schreef op ma 02-10-2023 om 10:21 [-0400]: > Wim Bertels <wim.bertels@ucll.be> writes: > > * but if you put more than 1 option, then it doesn't?: > > > #psql > > postgresql://myuser@myserver/mydb?connect_timeout=10&target_session > > _attrs=any > > Maybe you forgot to quote that? Ampersand is a shell metacharacter. yes indeed, & bg and fg, thank you Tom # psql 'postgresql://myuser@myserver/mydb?connect_timeout=10&target_session_at trs=any' or just # psql postgresql://myuser@myserver/mydb?connect_timeout=10'&'target_session_a ttrs=any > > (It does seem to work for me, as long as I put quotes around the > URL.) > > regards, tom lane
On 10/2/23 10:21, Wim Bertels wrote: > Tom Lane schreef op ma 02-10-2023 om 10:21 [-0400]: >> Wim Bertels <wim.bertels@ucll.be> writes: >>> * but if you put more than 1 option, then it doesn't?: >>> #psql >>> postgresql://myuser@myserver/mydb?connect_timeout=10&target_session >>> _attrs=any >> Maybe you forgot to quote that? Ampersand is a shell metacharacter. > yes indeed, & bg and fg, thank you Tom > > # psql > 'postgresql://myuser@myserver/mydb?connect_timeout=10&target_session_at > trs=any' > > or just > > # psql > postgresql://myuser@myserver/mydb?connect_timeout=10'&'target_session_a > ttrs=any Escaping the & using \ should also work. -- Born in Arizona, moved to Babylonia.