Calling psql from a bat file on windows?

From: "Oisin Glynn" <me(at)oisinglynn(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Calling psql from a bat file on windows?
Date: 2005-02-02 21:37:47
Message-ID: 003101c5096f$7370a870$a974fea9@homisco.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Andrew Hammond 2005-02-02 22:04:52 Re: grant all the database object automatically
Previous Message Mitch Pirtle 2005-02-02 20:41:51 Re: pgsql and adodb's genID() for unique id sequence...