Global .vsqlrc File

Moderator: NorbertKrupa

Post Reply
billykopecki
Beginner
Beginner
Posts: 42
Joined: Thu Apr 19, 2012 9:03 pm

Global .vsqlrc File

Post by billykopecki » Mon Jan 28, 2013 12:55 pm

Good morning,

I know that we can use the ~/.vsqlrc file to execute commands when starting vsql... But this file is tied to an OS user. Is there a global .vsqlrc file that we can use that will be read and executed for every user that runs vsql?

Thanks.

jpcavanaugh
Intermediate
Intermediate
Posts: 149
Joined: Mon Apr 30, 2012 10:04 pm
Location: New York
Contact:

Re: Global .vsqlrc File

Post by jpcavanaugh » Mon Jan 28, 2013 7:24 pm

I would take a look at /opt/vertica/config/vsqlrc but please be very careful editing this to make sure you do not cause issues for other scripts that might call into the default vsql (and not expecting your changes).

billykopecki
Beginner
Beginner
Posts: 42
Joined: Thu Apr 19, 2012 9:03 pm

Re: Global .vsqlrc File

Post by billykopecki » Mon Jan 28, 2013 9:48 pm

Thanks!!! The header of the file says it all:
  • --
    -- vsql configuration file
    --
    -- This file is read before the .vsqlrc file in the user's home directory.
    --
Hmm, I wonder if users will be able to over ride any global settings in their own .vsqlrc file. But , I guess that's the point of the local file :)

Post Reply

Return to “vSQL”