Sure,
http://stackoverflow.com/questions/6216432/windows-psql-command-line-is-there-a-way-to-allow-for-passwordless-login/6216838#6216838
Regards,
Grzegorz Szpetkowski
2011/6/5 eyal edri <eyal(dot)edri(at)gmail(dot)com>:
> 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.