We use the Cygwin version of the psql.exe program under Windows instead
of the native psql.exe program, even though the rest of the PostgreSQL
installation uses the standard native Windows versions of all the other
PostgreSQL components (database, tools, etc.). (So before I get flamed,
I want to clarify that the ONLY component of PostgreSQL that we use from
Cygwin is psql.exe, and it's run from an alternate directory.)
The main advantage that we get by using the Cygwin version of psql is
that is runs in "interactive" mode regardless of how it is run, whereas
the native psql program runs in non-interactive mode (showing almost no
output, no prompts, no readline support, etc.) when run from most
"shell" programs. We frequently run psql via a remote SSH connection or
from the RXVT terminal program or from inside Emacs, and in all of these
cases the native psql program runs in non-interactive mode whereas the
Cygwin version of psql is fully-functional.
- Bill
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org] On Behalf Of nac1967
> Sent: Saturday, August 04, 2007 3:01 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] v8.2 ... command line interface on Windows
>
>
> I am a PostgreSQL user, using the native windows version 8.2.
> I am new to PostgreSQL and am wondering if other users have
> suggestions regarding command line interfaces. I cannot for
> the life of me get readline to work on the Windows version.
> If you use IPython, for example, readline works fantastically
> with smart ctrl-P search of previous commands and tab
> completion. Does anyone know of a way either to get readline
> to work or another good command line interface?
>
> Thank you.
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
