Thread: Calling psql from a bat file on windows?

Calling psql from a bat file on windows?

From
"Oisin Glynn"
Date:

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

Re: Calling psql from a bat file on windows?

From
John DeSoi
Date:
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


Re: Calling psql from a bat file on windows?

From
"Todd Lewis"
Date:
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
>



Re: Calling psql from a bat file on windows?

From
"Oisin Glynn"
Date:
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
>