Re: Calling psql from a bat file on windows?

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
>