Re: How to pass the password for login in psql

["Oisin Glynn" <me@xxxxxxxxxxxxxx>]

BAT FILE SHOULD CONTAIN

set PGPASSWORD=postgres
"psql.exe" MYDATABASE -U postgres -f mysqlfile.sql


Oisin
----- Original Message ----- 
From: "Josef Springer" <Josef.Springer@xxxxxxxxx>
To: <pgsql-general@xxxxxxxxxxxxxx>
Sent: Tuesday, July 19, 2005 1:26 PM
Subject:  How to pass the password for login in psql


> Hi,
>
> i want to use psql using the --username option. But i do not find an
> option to pass the password. I want to use psql in a batch, so i want to
> automate it.
>
> Best Regards,
> Josef Springer
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faq


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq