On Feb 2, 2005, at 4:37 PM, Oisin Glynn wrote:
>
> I want to call a sql expression( and or file) from a bat file and pipe
> the result to a text file. Sounds super simple.. I am trying to use
> psql but I cannot find a way of passing the password to this. I want
> to schedule the bat file from windows scheduler.
>
> How can I pass the password to psql without human interaction? Or is
> there a smarter way to acheive this?
>
> I did try searching for an answer but if there is a faq I should be
> reading point me there
One option is to setup a .pgpass file. See
http://www.postgresql.org/docs/8.0/interactive/libpq-pgpass.html
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL