Re: Postgres in bash-mode

On Thu, Jan 10, 2002 at 09:07:50AM +0100, Alexander Pucher wrote:
> 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!

"Don't do that"

You CAN do something like
% psql -f dbscript database
Password: <typeity>
<stuff happens>
129195981 INSERT
%

--
David Terrell | "I went into Barnes and Noble to look for a
Prime Minister, Nebcorp | book on A.D.D., but I got bored and left."
dbt(at)meat(dot)net | - Benjy Feen
http://wwn.nebcorp.com/ |