Page 1 of 1

How to clear command history?

Posted: Mon Feb 23, 2015 2:43 pm
by hopewell
Hi,

The \s command lists all the commands in my vsql history. How can I erase the history?

Thank you

Re: How to clear command history?

Posted: Mon Feb 23, 2015 5:07 pm
by JimKnicely
Just delete or rename the history file: ~/.vsql_history

Re: How to clear command history?

Posted: Mon Mar 02, 2015 3:39 pm
by hopewell
Cool, thanks again Jim!

So, is there a separate history file for each user? Is it possible to just have a general one for all users? Just curious.

Re: How to clear command history?

Posted: Thu Mar 12, 2015 1:22 pm
by ViSolve
Hi hopewell,

Yes there can be separate history file if you configure to run Vertica in other user (other that dbadmin).
As of my knowledge it is not possible to have a general one for all users.

Regards,
Ruban

Re: How to clear command history?

Posted: Tue Mar 31, 2015 7:25 pm
by adrian.oprea
hopewell wrote:Cool, thanks again Jim!

So, is there a separate history file for each user? Is it possible to just have a general one for all users? Just curious.
Each user that can access Vertica locally it will have its own .vsql_history file in his home directory.