Re: PGPASSWORD

Tom Lane wrote:
> Oliver Jowett <oliver@opencloud.com> writes:
>
>>Assuming that you can't tweak .pgpass (for example, you're just
>>propagating a password you interactively got from the user), what's the
>>recommended way to provide the password?
>
>
> In the connection string given to PQconnectdb (or equivalent).

If you're a shell script calling psql / pg_dump / etc, how do you do this?

-O