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

From Julien Rouhaud
Subject Re: Multiple psql history files
Date
Msg-id 9da2d8ca-2f4c-97f1-bc07-d5e875e0c50f@dalibo.com
Whole thread Raw
In response to Multiple psql history files  (Jonathan Jacobson <jonjac@gmail.com>)
List pgsql-hackers
On 18/10/2016 18:26, Jonathan Jacobson 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.

You can already do this, for instance in your .psqlrc:

\set HISTFILE ~/.psql_history- :HOST - :PORT - :DBNAME - :USER


-- 
Julien Rouhaud
http://dalibo.com - http://dalibo.org



pgsql-hackers by date:

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