Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sPnev-006NXZ-S2 for pgsql-admin@arkaria.postgresql.org; Fri, 05 Jul 2024 18:27:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sPnet-00CpfJ-MA for pgsql-admin@arkaria.postgresql.org; Fri, 05 Jul 2024 18:27:48 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sPnet-00CpfB-AZ for pgsql-admin@lists.postgresql.org; Fri, 05 Jul 2024 18:27:48 +0000 Received: from jakobs.com ([85.214.83.89] helo=rs.plausibolo.de) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sPneq-000ZgZ-VG for pgsql-admin@lists.postgresql.org; Fri, 05 Jul 2024 18:27:46 +0000 Received: from localhost (localhost [127.0.0.1]) by rs.plausibolo.de (Postfix) with ESMTP id 201A5380618; Fri, 5 Jul 2024 20:27:42 +0200 (CEST) Received: from rs.plausibolo.de ([IPv6:::1]) by localhost (h2367442.stratoserver.net [IPv6:::1]) (amavisd-new, port 10024) with ESMTP id Y762L0EHW5d2; Fri, 5 Jul 2024 20:27:41 +0200 (CEST) Received: from [192.168.147.168] (dynamic-176-007-150-253.176.7.pool.telefonica.de [176.7.150.253]) by rs.plausibolo.de (Postfix) with ESMTPSA id 7EFCC380371; Fri, 5 Jul 2024 20:27:41 +0200 (CEST) Content-Type: multipart/alternative; boundary="------------Hadbip38ox0BSXc0KsMa9rnY" Message-ID: Date: Fri, 5 Jul 2024 20:27:40 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: psql on Windows systems To: pgsql-admin@lists.postgresql.org References: From: Holger Jakobs In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------Hadbip38ox0BSXc0KsMa9rnY Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Am 05.07.24 um 20:24 schrieb Zaid Shabbir: > On which windows platform you are > > Have you face the same behaviour with the windows installer ? > https://www.enterprisedb.com/downloads/postgres-postgresql-downloads > > On Fri, 5 Jul 2024 at 11:21 PM, Holger Jakobs wrote: > > Dear friends, > > Recently I had to use PostgreSQL on a Windows based system, and I was > surprised that the psql tool behaves differently, when it comes to > the > functionality of the readline library. > > There is no tab-completion for commands or schema/view/table names. > Also, browsing through previous commands within the history is > different > from the psql version on Linux systems. Only single lines, not > complete > commands show up in the history. > > This may be due to some library differences, but wouldn't it be > possible > to link some powerful readline and tab-completion libraries also on > Windows systems? > > Maybe it's a question for psql developers, should I write on a > different > list? > > Kind Regards, > > Holger > > -- > > Holger Jakobs, Bergisch Gladbach > > > Yes, I used the installer by Enterprise DB. It's an ordinary Windows 2022 server, but this doesn't make any difference. -- Holger Jakobs, Bergisch Gladbachchat with me on Signal messenger --------------Hadbip38ox0BSXc0KsMa9rnY Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit
Am 05.07.24 um 20:24 schrieb Zaid Shabbir:
On which windows platform you are 

Have you face the same behaviour with the windows installer ?

On Fri, 5 Jul 2024 at 11:21 PM, Holger Jakobs <holger@jakobs.com> wrote:
Dear friends,

Recently I had to use PostgreSQL on a Windows based system, and I was
surprised that the psql tool behaves differently, when it comes to the
functionality of the readline library.

There is no tab-completion for commands or schema/view/table names.
Also, browsing through previous commands within the history is different
from the psql version on Linux systems. Only single lines, not complete
commands show up in the history.

This may be due to some library differences, but wouldn't it be possible
to link some powerful readline and tab-completion libraries also on
Windows systems?

Maybe it's a question for psql developers, should I write on a different
list?

Kind Regards,

Holger

--

Holger Jakobs, Bergisch Gladbach




Yes, I used the installer by Enterprise DB. It's an ordinary Windows 2022 server, but this doesn't make any difference.


--

Holger Jakobs, Bergisch Gladbachchat with me on Signal messenger

--------------Hadbip38ox0BSXc0KsMa9rnY--