Thread: Calling psql from a bat file on windows?
Ok,
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
Oisin Glynn
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
Are you trying from dos or a flavor of unix? > Ok, > > 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 filefrom 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 > > Oisin Glynn >
windows 2000. ----- Original Message ----- From: "Todd Lewis" <lewis-todd@sbcglobal.net> To: <pgsql-novice@postgresql.org> Sent: Thursday, February 03, 2005 22:25 Subject: Re: [NOVICE] Calling psql from a bat file on windows? > Are you trying from dos or a flavor of unix? > > > Ok, > > > > 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 > > > > Oisin Glynn > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match >