From: | Lmhelp1 <lmhelp1(at)orange(dot)fr> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Commands history with psql in a Windows command line shell |
Date: | 2016-08-02 15:18:44 |
Message-ID: | 6a2534f3-4359-617d-d314-17174454eb6d@orange.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Melvin Davidson | 2016-08-02 15:31:44 | Re: Commands history with psql in a Windows command line shell |
Previous Message | Ladislav Lenart | 2016-08-02 15:16:37 | Re: consolidating data with window functions |