Re: [GENERAL] How to pass the password for login in psql

2005-07-19 Thread Scott Marlowe
file.sql > > > Oisin > - Original Message - > From: "Josef Springer" <[EMAIL PROTECTED]> > To: > Sent: Tuesday, July 19, 2005 1:26 PM > Subject: [GENERAL] How to pass the password for login in psql > > > > Hi, > > > > i wan

Re: [GENERAL] How to pass the password for login in psql

2005-07-19 Thread Tom Lane
Josef Springer <[EMAIL PROTECTED]> 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.

Re: [GENERAL] How to pass the password for login in psql

2005-07-19 Thread Oisin Glynn
BAT FILE SHOULD CONTAIN set PGPASSWORD=postgres "psql.exe" MYDATABASE -U postgres -f mysqlfile.sql Oisin - Original Message - From: "Josef Springer" <[EMAIL PROTECTED]> To: Sent: Tuesday, July 19, 2005 1:26 PM Subject: [GENERAL] How to pass the password f

[GENERAL] How to pass the password for login in psql

2005-07-19 Thread Josef Springer
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 ext