Postgres Pro
Downloads
Home   >   mailing lists

Re: Specifying psql password on command line - Mailing list pgsql-general

From Tom Lane
Subject Re: Specifying psql password on command line
Date
Msg-id 22573.991806811@sss.pgh.pa.us
Whole thread Raw
In response to Specifying psql password on command line  ("Tauren Mills" <tauren@servlets.net>)
Responses RE: Specifying psql password on command line  ("Tauren Mills" <tauren@servlets.net>)
List pgsql-general
Tree view 
"Tauren Mills" <tauren@servlets.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

pgsql-general by date:

Previous
From: "jackie"
Date:
Subject: Database Size
Next
From: Tom Lane
Date:
Subject: Re: Specifying psql password on command line