On Jul 23, 2007, at 8:32 AM, Raymond O'Donnell wrote:
On 23/07/2007 14:22, Perry Smith wrote:
First, you can specify a password with -P (I think --password
works also). psql --help for optins.
-P doesn't specify the password - see below:
C:\Documents and Settings\rod>psql --help
This is psql 8.2.4, the PostgreSQL interactive terminal.
Usage:
psql [OPTIONS]... [DBNAME [USERNAME]]
<snip>
Output format options:
<snip>
-P VAR[=ARG] set printing option VAR to ARG (see \pset command)
<etc...>
Ah... I knew that. I always assume it does, then it doesn't work,
then I look at the man page. Sorry.
(note that --password does not either. It just forces psql to prompt
for one).
Perry Smith ( pedz@xxxxxxxxxxxxxxxx )
Ease Software, Inc. ( http://www.easesoftware.com )
Low cost SATA Disk Systems for IBMs p5, pSeries, and RS/6000 AIX systems