how to run psql without password prompt when using auth MD5/Password

[eyal edri <eyal.edri@xxxxxxxxx>]

Hi,

Is there a way to run psql -U user -d dbname -c "select....."Â

without the psql asking for a password prompt from the user?Â

when setting the pg_hba.conf file to use md5 or password.

(btw, i've tried using ident, but couldn't make it work with jboss).

thanks!

Eyal.