Re: connect to postgres from shell scripts - Mailing list pgsql-admin

From Chris Travers
Subject Re: connect to postgres from shell scripts
Date
Msg-id 430A0FBA.80507@metatrontech.com
Whole thread Raw
In response to connect to postgres from shell scripts  (Hemapriya <priyam_1121@yahoo.com>)
List pgsql-admin
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

Attachment

pgsql-admin by date:

Previous
From: Simon de Hartog
Date:
Subject: Postgres using SSL connections
Next
From: "Dan"
Date:
Subject: DB restore fails W2k.