Re: Need help with bash script and postgresql

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(at)easesoftware(dot)com )
Ease Software, Inc. ( http://www.easesoftware.com )

Low cost SATA Disk Systems for IBMs p5, pSeries, and RS/6000 AIX systems