Tommy Flewwelling <tommyflewwelling@xxxxxxxxxxx> writes: > How do I specify in the command-line to access the .pgpass file when creating a database? Huh? You don't specify anything, it's done automatically when needed. > I don?t want to have to include (-W): > C:\postgressql\bin>createdb -U postgres ?p 5432 -W ?E UTF8 myDatabase You never have to include -W, whether you use .pgpass or not. That switch is only there for historical reasons. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly