You can put your password in pgpass.conf, see http://www.postgresql.org/docs/8.0/static/libpq-pgpass.html. It will affect all libpq applications though, and not just psql.
You can also put it in the PGPASSWORD environment variable with SET, but it's deprecated for security reasons (see http://www.postgresql.org/docs/8.0/static/libpq-envars.html) //Magnus > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of J Roy > Sent: Saturday, January 22, 2005 2:43 AM > To: pgsql-hackers@postgresql.org > Subject: [HACKERS] how to set password while loging into database > > Hi, > > Actually i installed postgresql 8.0 on my windows system. > After that i want to connect database through command prompt > so i type like this c:\programfiles\postgresql\8.0\bin>psql > -U postgres -d mydb when i typed the above command then it > asking password, when i give password it is able connect > otherwise it won't Here what my problem is in psql command i > want to give password after user name, it should not ask me > onceagain password, so is there any option to give password > within psql command. You can ask me why i am asking like this > if i want to run a batch file then i can not enter for each > every command the password, so pls help me and tell me how to > set password to commands like psql and createdb and other > commands. Pls help it's very urgent for me. > > My email id is [EMAIL PROTECTED] > > Thanks, > J R > > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index > scan if your > joining column's datatypes do not match > ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
