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