Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx> writes: > Kenji Morishige wrote: >> I've been stumped as to how to call psql from the command line without it >> prompting me for a password. Is there a enviornoment variable I can specify for >> the password or something I can place in .pgsql? I could write a perl wrapper >> around it, but I've been wondering how I can call psql -c without it prompting >> me. Is it possible? > Sure it is. Set up a .pgpass file. Also, consider whether a non-password-based auth method (eg, ident) might work for you. Personally, I wouldn't trust ident over TCP, but if your kernel supports it on unix-socket connections it is secure. regards, tom lane
