Hi,
The \s command lists all the commands in my vsql history. How can I erase the history?
Thank you
How to clear command history?
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: How to clear command history?
Just delete or rename the history file: ~/.vsql_history
Jim Knicely
![Image](http://vertica-forums.com/MyUploads/ASE_ebadge.png)
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
![Image](http://vertica-forums.com/MyUploads/ASE_ebadge.png)
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Re: How to clear command history?
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.
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?
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
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
Last edited by ViSolve on Thu Apr 02, 2015 10:29 am, edited 1 time in total.
-
- Intermediate
- Posts: 163
- Joined: Tue Jun 19, 2012 2:44 pm
- Location: Rio de Janeiro
- Contact:
Re: How to clear command history?
Each user that can access Vertica locally it will have its own .vsql_history file in his home directory.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.
trying so hard !!!