Re: How to pass the password for login in psql

From: "Oisin Glynn" <me(at)oisinglynn(dot)com>
To: "Josef Springer" <Josef(dot)Springer(at)JOOPS(dot)COM>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to pass the password for login in psql
Date: 2005-07-19 18:01:38
Message-ID: 006f01c58c8b$ec25f320$5a01a8c0@homisco.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

BAT FILE SHOULD CONTAIN

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

Oisin
----- Original Message -----
From: "Josef Springer" <Josef(dot)Springer(at)JOOPS(dot)COM>
To: <pgsql-general(at)postgresql(dot)org>
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
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-07-19 18:24:06 Re: How to pass the password for login in psql
Previous Message Dirk Lutzebäck 2005-07-19 17:48:59 Re: dump/restore needed when switching from 32bit to 64bit