Re: Postgres in bash-mode

<br /><font face="sans-serif" size="2">On 01/12/2002 06:03:44 PM Karl DeBisschop wrote:<br /> > On Sat, 2002-01-12
at03:32, David Terrell wrote:<br /> > > On Thu, Jan 10, 2002 at 09:07:50AM +0100, Alexander Pucher wrote:<br />
>> > I need to run a shell script that logs in to Postgresql, executes a<br /> > > > query and logs
offagain.<br /></font><br /><font face="sans-serif" size="2">> > > My problem is that I can't find a way to
putthe password in an 'psql'<br /> > > > statement at the prompt.<br /></font><br /><font face="sans-serif"
size="2">>If you absolutely need to do something like this, look into expect.<br /></font><br /><font
face="sans-serif"size="2">Woul be useful if there's an example expect script for this somewhere in the distribution or
documentation.Lots of people don't know expect, and don't want to learn it. They just want to automate database
tasks.</font><br/><br /><font face="sans-serif" size="2">Maarten</font><br /><font face="sans-serif" size="2"><br />
----<br/><br /> Maarten Boekhold, maarten.boekhold@reuters.com<br /><br /> Reuters Consulting / TIBCO Finance
TechnologyInc.<br /> Dubai Media City<br /> Building 1, 5th Floor<br /> PO Box 1426<br /> Dubai, United Arab
Emirates<br/> tel:+971(0)4 3918300 ext 249<br /> fax:+971(0)4 3918333<br /> mob:+971(0)505526539</font><code><font
size="3"><br/><br /> ------------------------------------------------------------- ---<br /> Visit our Internet site at
http://www.reuters.com<br/><br /> Any views expressed in this message are those of the individual<br /> sender, except
wherethe sender specifically states them to be<br /> the views of Reuters Ltd.<br /></font></code>