no prompt in psql!!! - Mailing list pgsql-general

From Gurjeet Singh
Subject no prompt in psql!!!
Date
Msg-id 65937bea0605272153t285e04c6p6d8a7e9cfaa232ab@mail.gmail.com
Whole thread Raw
Responses Re: no prompt in psql!!!
List pgsql-general
Hi,

    If I use mingw's rxvt.exe shell, I can't see any prompt in psql.
In a message to -patches
(http://archives.postgresql.org/pgsql-hackers-win32/2003-09/msg00019.php),
Bruce said:

The MinGW command console seems to have some problems with flushing
output to the screen (no prompt, no errors display), but the same binary
runs fine in CMD.EXE.  We can look at that later.

    I don't know if this problem has been fixed! I am running Win2K.
psql is running just fine from cmd.exe, and from the sh.exe run from
within that!! Following are the sessions:

From MinGW:

$ psql test postgres
\set
VERSION = 'PostgreSQL 8.2devel on i686-pc-mingw32, compiled by GCC
gcc.exe (GCC) 3.4.2 (mingw-special)'
AUTOCOMMIT = 'on'
VERBOSITY = 'default'
PROMPT1 = '%/%R%# '
PROMPT2 = '%/%R%# '
PROMPT3 = '>> '
DBNAME = 'test'
USER = 'postgres'
PORT = '5432'
ENCODING = 'SQL_ASCII'
\q

$

From CMD and sh within that:

E:\Documents and Settings\Gurjeet>psql test postgres
Welcome to psql 8.2devel, 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

Warning: Console code page (437) differs from Windows code page (1252)
         8-bit characters may not work correctly. See psql reference
         page "Notes for Windows users" for details.

test=# \set
VERSION = 'PostgreSQL 8.2devel on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
 3.4.2 (mingw-special)'
AUTOCOMMIT = 'on'
VERBOSITY = 'default'
PROMPT1 = '%/%R%# '
PROMPT2 = '%/%R%# '
PROMPT3 = '>> '
DBNAME = 'test'
USER = 'postgres'
PORT = '5432'
ENCODING = 'SQL_ASCII'
test=# \q

E:\Documents and Settings\Gurjeet>sh
sh-2.04$ psql test postgres
Welcome to psql 8.2devel, 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

Warning: Console code page (437) differs from Windows code page (1252)
         8-bit characters may not work correctly. See psql reference
         page "Notes for Windows users" for details.

test=# \set
VERSION = 'PostgreSQL 8.2devel on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
 3.4.2 (mingw-special)'
AUTOCOMMIT = 'on'
VERBOSITY = 'default'
PROMPT1 = '%/%R%# '
PROMPT2 = '%/%R%# '
PROMPT3 = '>> '
DBNAME = 'test'
USER = 'postgres'
PORT = '5432'
ENCODING = 'SQL_ASCII'
test=# \q
sh-2.04$

Thanks in advance,
Gurjeet.

pgsql-general by date:

Previous
From: Chris Browne
Date:
Subject: Re: Invoke diff from plpgsql?
Next
From: "P.M"
Date:
Subject: stored function and grant execute