How to clear command history?

Moderator: NorbertKrupa

Post Reply
hopewell
Beginner
Beginner
Posts: 29
Joined: Wed Mar 27, 2013 10:39 pm

How to clear command history?

Post by hopewell » Mon Feb 23, 2015 2:43 pm

Hi,

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

Thank you

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1806
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: How to clear command history?

Post by JimKnicely » Mon Feb 23, 2015 5:07 pm

Just delete or rename the history file: ~/.vsql_history
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

hopewell
Beginner
Beginner
Posts: 29
Joined: Wed Mar 27, 2013 10:39 pm

Re: How to clear command history?

Post by hopewell » Mon Mar 02, 2015 3:39 pm

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.

ViSolve
Newbie
Newbie
Posts: 1
Joined: Tue Jan 27, 2015 1:18 pm

Re: How to clear command history?

Post by ViSolve » Thu Mar 12, 2015 1:22 pm

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
Last edited by ViSolve on Thu Apr 02, 2015 10:29 am, edited 1 time in total.

adrian.oprea
Intermediate
Intermediate
Posts: 163
Joined: Tue Jun 19, 2012 2:44 pm
Location: Rio de Janeiro
Contact:

Re: How to clear command history?

Post by adrian.oprea » Tue Mar 31, 2015 7:25 pm

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.
trying so hard !!!

Post Reply

Return to “vSQL”