Re: Seperate command-line histories for seperate databases

Peter Eisentraut wrote:
> Someone sent the following request to the Debian bug tracking system:
>
> """
> It'd be nice if the .psql_history file were per-database. This is
> because the commands executed on different databases are likely to be
> very different, so there is no good reason to lose history for db1 when
> working with db2, especially since the new history from db2 is probably
> not useful for db1.
>
> I'd suggest giving psql a directory, and naming history like this:
>
> .psql/history/hostname/dbname
> """
>
> There is undoubtedly some merit to that, but I still have my doubts. But at
> least we can discuss it. Comments?

The psql manual pages for 8.1 now has:

HISTFILE
The file name that will be used to store the his-
tory list. The default value is ~/.psql_history.
For example, putting

\set HISTFILE ~/.psql_history- :DBNAME

in ~/.psqlrc will cause psql to maintain a separate
history for each database.

--
Bruce Momjian http://candle.pha.pa.us
SRA OSS, Inc. http://www.sraoss.com

+ If your life is a hard drive, Christ can be your backup. +