Hemapriya wrote:
Hi, I would like to know how to connect to postgres from shell scripts using a password protected user.
psql is the simple way.
Is there a way to embed the password in psql login. It keeps prompting for the passwords.
Use the .pgpass file to store the password. Best Wishes, Chris Travers Metatron Technology Consulting
begin:vcard fn:Chris Travers n:Travers;Chris email;internet:chris@xxxxxxxxxxxxxxxx x-mozilla-html:FALSE version:2.1 end:vcard