Postgres Pro
Downloads
Home   >   mailing lists

Re: How to pass the password for login in psql - Mailing list pgsql-general

From Tom Lane
Subject Re: How to pass the password for login in psql
Date
Msg-id 8013.1121797446@sss.pgh.pa.us
Whole thread Raw
In response to How to pass the password for login in psql  (Josef Springer <Josef.Springer@JOOPS.COM>)
List pgsql-general
Tree view 
Josef Springer <Josef.Springer@JOOPS.COM> writes:
> i want to use psql using the --username option. But i do not find an
> option to pass the password.

There are very good reasons for that.

> I want to use psql in a batch, so i want to automate it.

Consider using a ~/.pgpass file.

            regards, tom lane

pgsql-general by date:

Previous
From: "Oisin Glynn"
Date:
Subject: Re: How to pass the password for login in psql
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Converting MySQL tinyint to PostgreSQL