On Wednesday 28 November 2007, Marten Lehmann <lehmann@xxxxxx> 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