Re: [GENERAL] The .pgpass file

2007-11-07 Thread Alvaro Herrera
Tommy Flewwelling wrote: > > Hello, > > How do I specify in the command-line to access the .pgpass file when > creating a database? You don't. If the file exists and has the correct permission, createdb will read it. If the needed password is found, the connection will be done without ever p

Re: [GENERAL] The .pgpass file

2007-11-07 Thread Peter Eisentraut
Am Mittwoch, 7. November 2007 schrieb Tommy Flewwelling: > How do I inform the complier to extract the password from the file and not > the prompt the user? It does that automatically. Just omit the -W option. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---

Re: [GENERAL] The .pgpass file

2007-11-07 Thread Tom Lane
Tommy Flewwelling <[EMAIL PROTECTED]> 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 –

[GENERAL] The .pgpass file

2007-11-07 Thread Tommy Flewwelling
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):