Re: specifying a password on the cmd line for db connect

On 16/11/2009 22:51, Gauthier, Dave wrote:
> Hi:
>
> Is there a way to require and specify a password at the cmd line for a connect?  At first glance...
>
> --username foo  --password fee
>
> would seem to be what I want.  But it just prompts me for a password (after interpreting "fee" as the DB name).

Hi there,

There are no options such as these....what you do instead is use a
pgpass file:

  http://www.postgresql.org/docs/8.4/static/libpq-pgpass.html

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie