FYI, this is deprecated in favor of a .pgpass file.

See:

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

On Tue, 2005-07-19 at 13:01, Oisin Glynn wrote:
> BAT FILE SHOULD CONTAIN
> 
> set PGPASSWORD=postgres
> "psql.exe" MYDATABASE -U postgres -f mysqlfile.sql
> 
> 
> Oisin
> ----- Original Message ----- 
> From: "Josef Springer" <[EMAIL PROTECTED]>
> To: <[email protected]>
> Sent: Tuesday, July 19, 2005 1:26 PM
> Subject: [GENERAL] 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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to