The .pgpass file

Hello,

 

How do I specify in the command-line to access the .pgpass file when creating a database?

 

I would like to use ~/.pgpass instead of –W on the command line when creating a database (createdb) and was wondering the correct syntax.

 

For example,

 

I don’t want to have to include (-W):

C:\postgressql\bin>createdb -U postgres –p 5432 -W –E UTF8 myDatabase

 

 

and substitute it for ~/.pgpass or PGPASSFILE:

 

C:\postgressql\bin>createdb -U postgres –p 5432 ~/.pgpass –E UTF8 myDatabase

 

 

How do I inform the complier to extract the password from the file and not the prompt the user?

 

Any suggestions would be greatly appreciated.

 

Tommy_

---

R U Ready for Windows Live Messenger Beta 8.5? Try it today!