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@xxxxxxxxxxxxxx > [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of nac1967 > Sent: Saturday, August 04, 2007 3:01 PM > To: pgsql-general@xxxxxxxxxxxxxx > Subject: 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 > ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
