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
Devrim GUNDUZ <[EMAIL PROTECTED]> writes:
> psql checks for PGUSER, PGPASSWORD, PGHOST, PGPORT, PGDATABASE and some
> other environmental variables. Export relevant values to the parameters.
PGPASSWORD is deprecated because it is insecure on some platforms
(to wit, those where other users can see
PROTECTED] Behalf Of Hemapriya
Sent: Monday, August 22, 2005 10:43 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] connect to postgres from shell scripts
Hi,
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
-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 f
Hi,
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.
Any hint is appreciated.
Thanks
Priya
