----- Original Message -----
From: longlong
thanks !
:-)
P.S)
GUI edit can do pgpass.conf in pgAdminIII.
Please use it.!
Regards,
Hiroshi Saito
2007/10/10, Hiroshi Saito <z-saito@xxxxxxxxxxxxxxxx>:
Hi.
----- Original Message -----
From: longlong
if it is not in Command Prompt how can i work in a .bat file like that.
and i don't want the user input password,no interaction.
Ahh, Ok.
Please see.
http://developer.postgresql.org/pgdocs/postgres/libpq-pgpass.html
notepad "%APPDATA%\postgresql\pgpass.conf"
--edit-sample--
*:5433:postgres:postgres:postgres
It follows. This is not request password.
C:\Program Files\PostgreSQL\8.3-beta1\bin>psql postgres postgres
Welcome to psql 8.3beta1, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
postgres=# \q
I want this to help you.:-)
Regards,
Hiroshi Saito
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
