Re: about Command Prompt.

----- 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(at)guitar(dot)ocn(dot)ne(dot)jp>:
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