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.LNX.4.63.0508222034501.30926@xxxxxxxxxx> -----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--
