Re: Win32 Postgresql Command Line Password Specification

On Feb 8, 2005, at 3:11 AM, Andrei Bintintan wrote:

>
> I have to run some command line commands that I have to run on a
> windows machine. Like pgsql, dropdb, createdb etc.
> All these commands are runned from a php scripts.
>  
> Now, my question is how can I specify a User and Password to
> postgresql database system. I found out how can I say the user, but
> the password is always asked in the command line. I need this also to
> be specified in the command.

The recommended method is to use the pgpass.conf file on Windows:

http://www.postgresql.org/docs/8.0/interactive/libpq-pgpass.html

There is also a PGPASSWORD environment variable, but this is
depreciated for security reasons.

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL