From: | Alexander Pucher <pucher(at)atlas(dot)gis(dot)univie(dot)ac(dot)at> |
---|---|
To: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Postgres in bash-mode |
Date: | 2002-01-10 08:07:50 |
Message-ID: | 3C3D4BD6.3060607@atlas.gis.univie.ac.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
I hope, that this is not too off topic for this list, but anyway, it
should be easy for any PG-expert.
I need to run a shell script that logs in to Postgresql, executes a
query and logs off again.
In MySQL, I did it like this:
'mysql -u user -ppassword < script.sh'
My problem is that I can't find a way to put the password in an 'psql'
statement at the prompt.
Any suggestions are welcome!
mfg
ALEX
--
________________________________________________________
Institut fuer Geographie und Regionalforschung
Universität Wien
Kartografie und Geoinformation
Departement of Geography and Regional Research
University of Vienna
Cartographie and GIS
Universitaetstr. 7, A-1010 Wien, AUSTRIA
Tel: (+43 1) 4277 48644
Fax: (+43 1) 4277 48649
E-mail: pucher(at)atlas(dot)gis(dot)univie(dot)ac(dot)at
FTP: ftp://ftp.gis.univie.ac.at
WWW: http://www.gis.univie.ac.at/karto
________________________________________________________
"He that will not apply new remedies must expect new evils; for time is the greatest innovator"--Francis Bacon
From | Date | Subject | |
---|---|---|---|
Next Message | Justin Clift | 2002-01-10 09:16:25 | Re: Increasing checkpoint distance helps 7.2 noticeably |
Previous Message | Oleg Bartunov | 2002-01-10 06:32:37 | Re: RC1 time? |