Re: about Command Prompt. - Mailing list pgsql-general

From Hiroshi Saito
Subject Re: about Command Prompt.
Date
Msg-id 08b801c80afe$a8f99900$c601a8c0@HP22720319231
Whole thread Raw
In response to about Command Prompt.  (longlong <asfnuts@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Jasbinder Singh Bali"
Date:
Subject: Re: SLEEP in posgresql
Next
From: "Stuart Cooper"
Date:
Subject: Re: about Command Prompt