Re: [GENERAL]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 <[EMAIL PROTECTED]>: 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/
Re: [GENERAL]about Command Prompt
about Command Prompt: http://www.commandprompt.com/about/ ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [GENERAL]about Command Prompt.
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 5: don't forget to increase your free space map settings
Re: [GENERAL]about Command Prompt.
Hi. runas is not required. for example) C:\Program Files\PostgreSQL\8.3-beta1\bin>psql -f filename.sql postgres postgres Password for user postgres: pleae see. psql --help Regards, Hiroshi Saito - Original Message - From: longlong To: pgsql-general@postgresql.org Sent: Tuesday, October 09, 2007 9:25 PM Subject: [GENERAL]about Command Prompt. what i want is using the psql to excute a serial SQL command like create table in a file. but i have tried " runas /noprofile /env /user:postgres "f:\postgre\bin\psql -f filename" "in Windows cmd ,it doesn't work. Is there any way to do this or How can I make my order work just like in Command Prompt? ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
[GENERAL]about Command Prompt.
what i want is using the psql to excute a serial SQL command like create table in a file. but i have tried " runas /noprofile /env /user:postgres "f:\postgre\bin\psql -f filename" "in Windows cmd ,it doesn't work. Is there any way to do this or How can I make my order work just like in Command Prompt?