[ADMIN] Connect to postgres from a script using password

2004-07-08 Thread Hemapriya
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 __

Re: [ADMIN] Connect to postgres from a script using password

2004-07-08 Thread Bruno Wolff III
On Thu, Jul 08, 2004 at 09:07:30 -0700, Hemapriya <[EMAIL PROTECTED]> wrote: > 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

Re: [ADMIN] Connect to postgres from a script using password

2004-07-08 Thread Devrim GUNDUZ
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Thu, 8 Jul 2004, Hemapriya wrote: > 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 includ