On Tue, Oct 11, 2016 at 5:06 PM, Oskari Saarenmaa <o...@ohmu.fi> wrote: > $ PASSWORD=xyz psql 'password=$PASSWORD dbname=foo' > > This does have the hazard of making it very easy to accidentally use double > quotes instead of single quotes and have the shell expand the variable > making it visible in process listing though.
It has the hazard that environment variables are visible in the process listing anyway on many platforms. On Linux, try "ps auxeww"; on MacOS X, try "ps -efEww". At a quick glance, it seems that on both of those platforms you have to either be root or be the same user that owns the process, but I'm not sure that every platform will have it locked down that tightly and even that might be more exposure than you really want. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers