Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qnfZA-00BavX-RJ for pgsql-general@arkaria.postgresql.org; Tue, 03 Oct 2023 13:36:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qnfZ8-005iBX-Eh for pgsql-general@arkaria.postgresql.org; Tue, 03 Oct 2023 13:35:58 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qnfZ8-005iAn-3h for pgsql-general@lists.postgresql.org; Tue, 03 Oct 2023 13:35:58 +0000 Received: from mail-yb1-xb2a.google.com ([2607:f8b0:4864:20::b2a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qnfZ5-007yxT-Vb for pgsql-general@lists.postgresql.org; Tue, 03 Oct 2023 13:35:57 +0000 Received: by mail-yb1-xb2a.google.com with SMTP id 3f1490d57ef6-d852b28ec3bso957117276.2 for ; Tue, 03 Oct 2023 06:35:55 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1696340155; x=1696944955; darn=lists.postgresql.org; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=0LdAeB81ITWF6tsNg/d/5aJ6vFzA4xz8K277c3sGZdE=; b=Dr6BlC6yl9O2YNxLmpbzjNK42HfvoiSp5Zgz0rBT3L9Ayeg9gGJB3yp6Idzh50vqZf PlumRIc+ri4XfWwkvcdYJsEdyTpkpY7sWtMlaryv0lHUqxdfz5m+OCZyD+YksR/1onxH znsmYV5pfHr4BQjGDu43TPecft4OoRtRDQNvqJZQMOspp9nHGl1X23WbdcEC+AGFYmja H/NOui4IkP2Nwfh3lQ5a0KC9H/qNfk3bba/PtwJE+ohMngZDV1u06RQv3Egw3ps6jLYs V75q4at2HKvvdxM8DTFuuMSVgOUUVyZrM0SCQpE78w7WCsj4RgJnYkjGfFf0DumotGIr YHpw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1696340155; x=1696944955; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=0LdAeB81ITWF6tsNg/d/5aJ6vFzA4xz8K277c3sGZdE=; b=nSUd/clq+JU56AgrJlyCUyfES01cPiTgizqziYIdvnqFgvXW6j75flz3ZChGQKU2RS O0dLqFD6/vAptibjGuxi4BZBJu6SKISfKy/ykZ3tKrbSIAdjJfBAWo65pZTiblVPt3oG uT5EGN4+1O618DHBgIsmriQAt2+Dy5PpBZVb7daRYjv2Zdz5ZUS6J+FtSSt4Xd0UMGiX rbUlVecMkR6cCCAVEBG7HgfSed0W3Er0KiEZlUP6IMUdndxNPA9iqCTZdc9dyIlr/wLq 1iTPUg0kqU+M2wAjWezs/64/3tnyK1VG/WPde+eondC0kbwlLjC7zOQzmCXhh+za77hi JhEA== X-Gm-Message-State: AOJu0YwaJHGsFJtJYQktZBmh1XNCAxd+fZ+GUsjRqjN+lyb9RjFh34Ra 2uBKWFM+G1U2jM+HyZP9LzKwIXgy7Uw= X-Google-Smtp-Source: AGHT+IEJ6GvQ6z18LNtM2a+OuXCijwhcYxt5U4Lobzm7lKRTQ80W/7NOCMjwGk/giy/rmMsSfnlD0Q== X-Received: by 2002:a25:f90a:0:b0:d71:8e8c:5233 with SMTP id q10-20020a25f90a000000b00d718e8c5233mr12167242ybe.12.1696340155053; Tue, 03 Oct 2023 06:35:55 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:a9ff:8e0:a7ce:5aa0? ([2600:1700:bd2c:b810:a9ff:8e0:a7ce:5aa0]) by smtp.googlemail.com with ESMTPSA id c196-20020a25c0cd000000b00babcd913630sm410400ybf.3.2023.10.03.06.35.54 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 03 Oct 2023 06:35:54 -0700 (PDT) Message-ID: <5440513c-9d1b-8b45-9023-e2ebc97b6d19@gmail.com> Date: Tue, 3 Oct 2023 08:35:54 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.11.0 Subject: Re: specifying multiple options in URI psql behaviour? Content-Language: en-US To: pgsql-general@lists.postgresql.org References: <2018730.1696256489@sss.pgh.pa.us> From: Ron In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 10/2/23 10:21, Wim Bertels wrote: > Tom Lane schreef op ma 02-10-2023 om 10:21 [-0400]: >> Wim Bertels 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.