Re: Multiple psql history files - Mailing list pgsql-hackers

From Corey Huinker
Subject Re: Multiple psql history files
Date
Msg-id CADkLM=f1pkL4YXiM8GR+23ohtktuwaiL0gQJK3WBxTmV6+jw8w@mail.gmail.com
Whole thread Raw
In response to Multiple psql history files  (Jonathan Jacobson <jonjac@gmail.com>)
List pgsql-hackers
On Tue, Oct 18, 2016 at 12:26 PM, Jonathan Jacobson <jonjac@gmail.com> wrote:
The .psql_history file is naturally used by different DB connections (distinguished by a different combination of host + port + database + user).
At least in my multi-database working environment, this leads sometimes to frustration because there are commands that cannot or should not be used by different connections.
To solve this, psql could keep a separate command history file for each connection.
I will be happy to make this my first contribution to PostgreSQL's code.
What do you say?

Regards,
Jonathan

That's settable with HISTFILE

\set HISTFILE ~/.psql_history- :DBNAME

There's also :PORT and a few other vars. 

pgsql-hackers by date:

Previous
From: Jonathan Jacobson
Date:
Subject: Multiple psql history files
Next
From: "David G. Johnston"
Date:
Subject: Re: Multiple psql history files