Michael Devogelaere <michael(at)mind(dot)be> writes:
> With the previous version, i passed the password with
> 'echo pass | psql -d db -U user -h server -c "..."'
> but that doesn't seem to work anymore (because it reads the password now
> from /dev/tty instead of stdin i guess).
This was a deliberate change (some of us had misgivings about it but
were voted down).
I'd suggest seeing if you can't avoid needing passwords anymore,
instead. "ident" auth works over local connections now (at least
on some platforms, including recent Linuxen).
regards, tom lane