Thread: 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
BAT FILE SHOULD CONTAIN set PGPASSWORD=postgres "psql.exe" MYDATABASE -U postgres -f mysqlfile.sql Oisin ----- Original Message ----- From: "Josef Springer" <Josef.Springer@JOOPS.COM> To: <pgsql-general@postgresql.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 > >
Josef Springer <Josef.Springer@JOOPS.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
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" <Josef.Springer@JOOPS.COM> > To: <pgsql-general@postgresql.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 > > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq