how can i pass the user and password in single statement

From: "mallikarjun(dot)revgond" <mallikarjun(dot)revgond(at)valtech(dot)co(dot)in>
To: <pgsql-committers(at)postgresql(dot)org>
Subject: how can i pass the user and password in single statement
Date: 2005-12-14 06:28:08
Message-ID: INBLR-EF014WZiW7MiU0002c04c@inblr-ef01.valtechindia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Hi

I want to run a .sql file through a batch file such as below

psql -f C:\test\test.sql testdb postgres

when I run this batch file the, command prompt will request for db
password, so my problem is how can I pass the password value in a single
statement of psql command

please any body help in this regard

thanks in advance

Mallikarjun

#30/A, First Main Road, J.P.Nagar, Third Phase,

Opposite Jayadeva Hospital, Bangalore 560 078
Off: 80-26079000 Ext 9736| Mob: 9448200569
<http://www.valtech.com/> www.valtech.com

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message James William Pye 2005-12-14 06:37:21 python - be: Remove "conv" and some dead code.
Previous Message James William Pye 2005-12-14 04:43:48 python - be: Remove "tif".