how to set password while loging into database - Mailing list pgsql-hackers

From J Roy
Subject how to set password while loging into database
Date
Msg-id MGENKFBAFHIIJCPOONECAENOCAAA.Jithendra.Roy@effone.net
Whole thread Raw
List pgsql-hackers
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 jith_n@yahoo.com

Thanks,
J R





pgsql-hackers by date:

Previous
From: Anand Kumria
Date:
Subject: Re: ARC patent
Next
From: Tom Lane
Date:
Subject: Re: [PATCHES] WAL: O_DIRECT and multipage-writer