Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qFTlG-0007lR-Pd for pgsql-general@arkaria.postgresql.org; Sat, 01 Jul 2023 06:07:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qFTlF-0000Td-EZ for pgsql-general@arkaria.postgresql.org; Sat, 01 Jul 2023 06:07:09 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qFTlF-0000TT-43 for pgsql-general@lists.postgresql.org; Sat, 01 Jul 2023 06:07:09 +0000 Received: from mail-pl1-x62a.google.com ([2607:f8b0:4864:20::62a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qFTl8-001PKN-C4 for pgsql-general@lists.postgresql.org; Sat, 01 Jul 2023 06:07:07 +0000 Received: by mail-pl1-x62a.google.com with SMTP id d9443c01a7336-1b6824141b4so15815325ad.1 for ; Fri, 30 Jun 2023 23:07:02 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1688191621; x=1690783621; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=omTjd69CBFCKpbllowQoWjK+El16Jwt3Rh5iePN6/Ak=; b=f4EJ6c2tDTQ4XcpJuBhnUASoYOMV8f4JNMNhki+wTIVPjYnNa/Tpq1RNbwh0rK05C4 /h4kuS+ph1FCQhQ/JkpTp/GZ3q9xki3F3IEZ34wVwg/8iIQV/tpc9ekKbENuY4fS5AES +ZT6/G2iWPY7zUYh2hFFSfa25boaqGME7ZvTqerbfjhtRvPrPNXlcK2McDT3R0C2eDi1 XQVJh1Hd4taDJOM76fMZ6QISqWo28QwYAYh74rXZuB/roGbfSVurMLTdIY0e3/5t2yV5 0d8Rlmjd4DSuyOZI6pM1QgK9GXDj+9Ak10ZYNz+SZP8+LxABZOSOTvHDHXRAs7FTCEg4 NPjw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1688191621; x=1690783621; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=omTjd69CBFCKpbllowQoWjK+El16Jwt3Rh5iePN6/Ak=; b=Ygj2ipQ3GaD0J/Ggl7vB8RqKH5PXGVs5TGtwExQTINARR5eUthGO1CHJ6/zOmK9VlZ GUXZVqddapCEY2S8+lHGPl6k21KzXV9TogdE0HJuDK8+g9zcbkJ5fvsmOE2paFmJJlQo PGBuUGtKUuD/4TV/aIHC66xhNk/u9ORirHTIX1e0n3t3c4c/sQCFntsJTNAPIn5BRyV9 gc6+4Xt5bYiw3eeH72+jtmAeQE+QGb43VzX0TF0cmRKbzqa/n03WvNs03OF2KirYHhqN FU5hjf73VIYcv1Nyvs/2XMY8dI8gGC7DKKQQe6Y5T8x+4ePZaRaw8j69vn2jGa67nZ6m 32Kg== X-Gm-Message-State: ABy/qLamMAbFRs2lfmsAy6o/hu8JEHqK57Byc4TAyWHhiTA1/SjsCanq ks75NxUVfDkOgjdcJpQPwIg= X-Google-Smtp-Source: APBJJlF4PTwypf6o07mPdfTQyQ+3Y4sCfMQPVKVx26rLJqTufCe6OIFNbSF/g23Gc4WN0KGO47q03w== X-Received: by 2002:a17:903:32c8:b0:1b8:5bca:8267 with SMTP id i8-20020a17090332c800b001b85bca8267mr9667111plr.25.1688191621134; Fri, 30 Jun 2023 23:07:01 -0700 (PDT) Received: from jrouhaud (2001-b011-1005-79ab-64da-2485-b7d6-0db7.dynamic-ip6.hinet.net. [2001:b011:1005:79ab:64da:2485:b7d6:db7]) by smtp.gmail.com with ESMTPSA id q22-20020a170902b11600b001b7ffca7dbcsm9609724plr.148.2023.06.30.23.06.59 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 30 Jun 2023 23:07:00 -0700 (PDT) Date: Sat, 1 Jul 2023 14:06:57 +0800 From: Julien Rouhaud To: Kirk Wolak Cc: pf@pfortin.com, pgsql-general@lists.postgresql.org Subject: Re: psql and pgpass.conf on Windows Message-ID: <20230701060657.xesvncdjkhz7j2at@jrouhaud> References: <20230629224200.080cc1a4.pfortin@pfortin.com> <20230630031636.jot6q5v77dlinlro@jrouhaud> <20230630083854.1668913d@pfortin.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sat, Jul 01, 2023 at 01:40:49AM -0400, Kirk Wolak wrote: > > FWIW, I discovered that psql is case sensitive on the dbname, without > quoting it! That's on purpose, since shell quoting behavior is entirely different from SQL. The quotes are discarded by the shell, so it would otherwise require users doing something like psql -d '"MyDbName"' The behavior is the same for all client tools, and other object arguments like username.