Search Postgresql Archives

Re: Commands history with psql in a Windows command line shell

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Thank you for your answer.

cmd.exe> psql --version
psql (PostgreSQL) 9.5.2

Like I wrote, the Windows OS is 8.1 Pro.

Best regards,
--
Léa Massiot


On 2016-08-02 5:31 PM, Melvin Davidson wrote:
Are you doing this in PostgreSQL 7.3 and Windows XP? Can you provide us with a little more useful information like current PostgreSQL version and O/S?
Otherwise we have absolutely no idea what the problem might be.

On Tue, Aug 2, 2016 at 11:18 AM, Lmhelp1 <lmhelp1@xxxxxxxxx> wrote:
Hello,

I am using "psql" in "cmd.exe" in Windows (8.1).

Below is the command I use to connect to a database with "psql":
cmd.exe> psql -p <tcp_port> -U <username> <database_name>

My problem is the following.
Suppose I enter one command:
<database_name># SELECT * FROM <a_table_1>;
and then another one:
<database_name># SELECT * FROM <a_table_2>;
The commands history "is not working": meaning I cannot retrieve these last two commands I entered by hitting the top arrow key.
Instead, I have to type them again.

To try to solve the problem, I entered the command:
<database_name># \set HISTSIZE 100
but it didn't change anything.

Yesterday, I don't remember what I did, but I could access the commands history using Powershell, maybe the command "\set HISTSIZE 100" and maybe a "psqlrc" file.
But whatever I've been trying to do since, I can't make it work again.

Can you please advise me what to do to make this work?

Best regards.
--
Léa Massiot



--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux