Connect to postgres from a script using password

From: Hemapriya <priyam_1121(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Connect to postgres from a script using password
Date: 2004-07-08 16:07:30
Message-ID: 20040708160730.73409.qmail@web21326.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

Can anyone tell me how to connect to postgres from a
shell script using password. If i use psql -UUser db
-W option it prompts for password everytime..
Is there anyway we can have the password included in
psql login command.?

Thanks
Priya


__________________________________
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
http://promotions.yahoo.com/new_mail

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Devrim GUNDUZ 2004-07-08 16:44:09 Re: Connect to postgres from a script using password
Previous Message Oliver Elphick 2004-07-08 16:00:49 Re: cross databases?