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@xxxxxxx> 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.