The .pgpass file - Mailing list pgsql-general

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_