Re: [GENERAL] How to automate password requests?

On Wednesday 28 November 2007, Marten Lehmann <lehmann@cnm.de> wrote:
> Hello,
>
> I'm trying to automate some postgresql scripts, but I cannot find a way
> to pass a password directly to commands like pg_dump psql and so on.
> Even a
>
> echo "password" | psql
>
> doesn't work, the password prompt of psql is still waiting.
>
> mysql has the -p option. What would be the postgresql equivalent? I
> don't want to enter passwords dozend times.
>

create a .pgpass file.

-- 
The global consumer economy can best be described as the most efficient way  
to convert natural resources into waste.


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend