|
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 – and substitute it for ~/.pgpass or PGPASSFILE: C:\postgressql\bin>createdb -U postgres –p 5432 ~/.pgpass – 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! |
