Re: [GENERAL] How to pass the password for login in psql
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: > 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
Re: [GENERAL] How to pass the password for login in psql
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. regards, tom lane ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] How to pass the password for login in psql
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 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
[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