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@easesoftware.com )
Ease Software, Inc. ( http://www.easesoftware.com )
Low cost SATA Disk Systems for IBMs p5, pSeries, and RS/6000 AIX systems