From: | "Fabio D'Ovidio" <dovidio(at)planetek(dot)it> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | tragni(at)planetek(dot)it |
Subject: | psql : password on Win32 |
Date: | 2007-02-26 18:34:25 |
Message-ID: | 45E33641.17035.139CDF@dovidio.planetek.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-novice |
Hi folks !
I am new of the list even if I use PostgreSQL\PostGIS since I was in Planetek to work.
I have a problem with psql command line on Windows XP. I want to set password for the
user postgres in order to execute an sql script directly from a batch file without entering
password from the prompt.
The command is :
psql -U postgres -d mydb -f script.sql
I have used pgpass.conf file with the syntax :
localhost:5432:mydb:postgres:password
and it doesn't work.
How can i do ?
Thanks!
--
Fabio D'Ovidio
Web GIS Staff
Planetek Italia s.r.l.
Via Massaua 12, I-70123 Bari
Tel.: +39 080 5343750 Fax: +39 080 5340280
dovidio(at)planetek(dot)it - http://www.planetek.it
--
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2007-02-26 18:44:30 | Re: Composite Keys |
Previous Message | Anton Melser | 2007-02-26 18:24:57 | stored procedure optimisation... |
From | Date | Subject | |
---|---|---|---|
Next Message | Andrej Ricnik-Bay | 2007-02-26 19:10:25 | Re: [GENERAL] psql : password on Win32 |
Previous Message | Tom Lane | 2007-02-26 17:51:33 | Re: postgresql-server-8.2.3-1mdv2007.1.i586.rpm installation problem |