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