Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h9y8q-0005ia-LH for pgsql-hackers@arkaria.postgresql.org; Fri, 29 Mar 2019 20:30:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h9y8o-0001Mm-1a for pgsql-hackers@arkaria.postgresql.org; Fri, 29 Mar 2019 20:30:18 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h9y8n-0001Mf-PM for pgsql-hackers@lists.postgresql.org; Fri, 29 Mar 2019 20:30:17 +0000 Received: from feynman.df7cb.de ([195.49.152.168]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h9y8h-00014L-J2 for pgsql-hackers@lists.postgresql.org; Fri, 29 Mar 2019 20:30:17 +0000 Received: from msg.df7cb.de (unknown [IPv6:2a02:908:1478:70e0:76e5:bff:fef3:7e00]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by feynman.df7cb.de (Postfix) with ESMTPSA id 44WCz60CRPz3Dws; Fri, 29 Mar 2019 21:30:09 +0100 (CET) Date: Fri, 29 Mar 2019 21:30:09 +0100 From: Christoph Berg To: Joe Conway Cc: Pavel Stehule , Tom Lane , Andres Freund , Tatsuo Ishii , Andreas Karlsson , Tomas Vondra , eldmannen@gmail.com, mark.kirkwood@catalyst.net.nz, Michael Paquier , Chris Travers , Alvaro Herrera , Euler Taveira , rjuju123@gmail.com, PostgreSQL Hackers Subject: Re: PostgreSQL pollutes the file system Message-ID: <20190329203008.GE19154@msg.df7cb.de> References: <20190329.100407.1159785913847835944.t-ishii@sraoss.co.jp> <20190329152557.GI20294@msg.df7cb.de> <24256.1553874086@sss.pgh.pa.us> <20190329155121.5zyoahgh4i2r4ayl@alap3.anarazel.de> <19517.1553876700@sss.pgh.pa.us> <20190329185031.GA19154@msg.df7cb.de> <48e5efaf-7ea2-ed70-a803-949bbfec8f6b@joeconway.com> <20190329194330.GD19154@msg.df7cb.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Re: Joe Conway 2019-03-29 > >> echo "\password :\"role\"" | psql -v role='my role' > > > > It is on-topic because the reason we can't just tell people to replace > > createuser $foo > > with > > psql -c "create user $foo" > > is because $foo might need escaping. > > > > IMHO if we find an way to do that which is acceptable for sh scripts, > > the createuser/... commands could go. > > I think these commands *were* once (at least some of them) shell scripts > and we went to executable C in order to make them work on Windows, IIRC. I meant the interface to these programs. It needs to be something people can use in sh scripts without wtf'ing. The :\"weirdness\" | cited above is IMHO not acceptable. Christoph