Re: Specifying psql password on command line

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Tauren Mills" <tauren(at)servlets(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Specifying psql password on command line
Date: 2001-06-06 05:53:31
Message-ID: 22573.991806811@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Tauren Mills" <tauren(at)servlets(dot)net> writes:
> I've read the documentation for the psql commands as well as the createdb
> and dropdb commands. It looks like there is no way to specify the password
> on the command line. The password is always provided in the form of a stdin
> prompt.

Quite deliberately ... if passwords were provided on the command line,
then anyone else on your machine could read them off with 'ps'.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Justin Clift 2001-06-06 05:59:26 USE_AUSTRALIAN_RULES breaks regression tests in 7.1.2?
Previous Message jackie 2001-06-06 05:52:50 Database Size