Re: connect to postgres from shell scripts

From: Chris Travers <chris(at)metatrontech(dot)com>
To: Hemapriya <priyam_1121(at)yahoo(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: connect to postgres from shell scripts
Date: 2005-08-22 17:47:38
Message-ID: 430A0FBA.80507@metatrontech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
chris.vcf text/x-vcard 127 bytes

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jason Minion 2005-08-22 17:56:36 Re: connect to postgres from shell scripts
Previous Message Sean Chittenden 2005-08-22 17:46:06 Re: Corrupted data, best course of repair?