Re: v8.2 ... command line interface on Windows

On Aug 4, 5:23 pm, bbartl(dot)(dot)(dot)(at)softwareanalytics(dot)com ("Bill Bartlett")
wrote:
> Couldn't this be offered pre-built as an alternative in the Windows
> installer or as a "psql2.exe" program? Seems like there might be more
> than a few PostgreSQL users running with US keyboard layouts under
> native Windows, and providing the prebuilt version along with the
> "normal" one might eliminate many of the postings like this that keep
> reappearing on these lists.
>
> - Bill
>
>
>
> > -----Original Message-----
> > From: pgsql-general-ow(dot)(dot)(dot)(at)postgresql(dot)org
> > [mailto:pgsql-general-ow(dot)(dot)(dot)(at)postgresql(dot)org] On Behalf Of
> > Magnus Hagander
> > Sent: Saturday, August 04, 2007 3:09 PM
> > To: nac1967
> > Cc: pgsql-gene(dot)(dot)(dot)(at)postgresql(dot)org
> > Subject: Re: [GENERAL] v8.2 ... command line interface on Windows
>
> > nac1967 wrote:
> > > 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?
>
> > Readline only works with US keyboard layouts under native
> > windows, that's why it's been turned off in the binary
> > builds. You are left with the very limited commandline
> > editing in the default windows command shell.
>
> > If you are using only US keyboard layout, you can rebuild
> > psql from source (using the MingW build system) with
> > readline. You only need to rebuild psql - not libpq or the
> > backend itself.
>
> > //Magnus
>
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org/

Your suggestion makes a lot of sense to me. In fact, given the number
of compiler options that exist for the Unix/Linux build, the Windows
build is surprisingly devoid of options.