Re: v8.2 ... command line interface on Windows - Mailing list pgsql-general

nac1967 wrote:
> On Aug 4, 5:23 pm, bbartl...@softwareanalytics.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...@postgresql.org
>>> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of
>>> Magnus Hagander
>>> Sent: Saturday, August 04, 2007 3:09 PM
>>> To: nac1967
>>> Cc: pgsql-gene...@postgresql.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.

Not at all. All the options are there if you build from source, just
like on Unix. The binary build has picked one set of options - just like
the .deb build or the .rpm build has picked their sets of options. They
pick the options that makes the *most* sense on their platform in *most*
cases. If you need other options, you have to rebuild from source - just
like on Windows.

//Magnus