Re: connect to postgres from shell scripts

This message is in MIME format. The first part should be readable text,
while the remaining parts are likely unreadable without MIME-aware tools.

--8323328-932793750-1124732087=:30926
Content-Type: TEXT/PLAIN; CHARSET=iso-8859-9; FORMAT=flowed
Content-Transfer-Encoding: 8BIT
Content-ID: <Pine(dot)LNX(dot)4(dot)63(dot)0508222034501(dot)30926(at)emo(dot)org(dot)tr>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

On Mon, 22 Aug 2005, Hemapriya wrote:

> I would like to know how to connect to postgres from
> shell scripts using a password protected user.
>
> Is there a way to embed the password in psql login.
> It keeps prompting for the passwords.

psql checks for PGUSER, PGPASSWORD, PGHOST, PGPORT, PGDATABASE and some
other environmental variables. Export relevant values to the parameters.

http://www.postgresql.org/docs/8.0/static/libpq-envars.html

Also there's a .pgpass file thing:

http://www.postgresql.org/docs/8.0/static/libpq-pgpass.html

Regards,
- --
Devrim GUNDUZ
Kivi Bilişim Teknolojileri - http://www.kivi.com.tr
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFDCgzAtl86P3SPfQ4RAo5PAJ9y9Pm7ii8z50ZrSB7Bws1qhQU++gCfUepu
C3ErI3WBVLPIJ8ShVPE29Dk=
=dCI+
-----END PGP SIGNATURE-----
--8323328-932793750-1124732087=:30926--