Re: Calling psql from a bat file on windows?

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