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.
Regards Marten ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
