psql and passwords

Hi,

I've recently installed a beta-release of RedHat which ships PostgreSQL
7.2.1 and have troubles with using psql in non-interactive scripts.

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).

Is this a RedHat-specific issue or is it more general ? And of course:
what's the solution ? ;)


Kind regards,
Michael Devogelaere.