RE: [GENERAL] Specifying psql password on command line

> > 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 w

Re: [GENERAL] Specifying psql password on command line

"Tauren Mills" <[EMAIL PROTECTED]> writes: >> Quite deliberately ... if passwords were provided on the command line, >> then anyone else on your machine could read them off with 'ps'. > I was actually wondering if that was the reason. I know that with MySQL, > the mysql program immediately chang

Re: [GENERAL] Specifying psql password on command line

"Tauren Mills" <[EMAIL PROTECTED]> 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 delib

Re: [GENERAL] Specifying psql password on command line

preety simple.. In ur shell script use psql -h localhost ur_db -U ur_user_name 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 for