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