Re: The .pgpass file

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tommy Flewwelling <tommyflewwelling(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: The .pgpass file
Date: 2007-11-07 15:51:13
Message-ID: 17067.1194450673@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tommy Flewwelling <tommyflewwelling(at)hotmail(dot)com> 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 dont 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Simon Riggs 2007-11-07 15:51:46 Re: any way for ORDER BY x to imply NULLS FIRST in 8.3?
Previous Message Karsten Hilbert 2007-11-07 15:45:54 Re: md5() sorting