Re: My troubles with test PostgreSQL 8.1

Hi Kevin,

On Nov 10, 2005, at 5:09 PM, Kevin Rosenberg wrote:

> Thanks for the postgresql tips. Connecting to stdin for
> dropdb and pass the password to dropdb's prompt would be secure. But,
> I doubt that'd be very portable across lisp implementation or
> operating systems. At this point, I think the current behavior is
> preferred to passing the SQL password on the command-line to dropdb.

In fact I don't think it is even possible to put the password on the  
command line. The -W/--password parameter just forces a password  
prompt. The only way would be to connect to stdin to send it or give  
up unless there is a .pgpass file.

Best,

John




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