Re: How to pass the password for login in psql

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Josef Springer <Josef(dot)Springer(at)JOOPS(dot)COM>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to pass the password for login in psql
Date: 2005-07-19 18:24:06
Message-ID: 8013.1121797446@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Josef Springer <Josef(dot)Springer(at)JOOPS(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jim C. Nasby 2005-07-19 18:28:11 Re: Converting MySQL tinyint to PostgreSQL
Previous Message Oisin Glynn 2005-07-19 18:01:38 Re: How to pass the password for login in psql