vsql environment variables

Set one or more of the following environment variables to be used by the defined properties automatically, each time you start vsql:.

Set one or more of the following environment variables to be used by the defined properties automatically, each time you start vsql:

PAGER
If the query results do not fit on the screen, they are piped through this command. Typical values are more or less. The default is platform-dependent. Use the \pset command to enable/disable the pager.
VSQL_DATABASE
The database to which you are connecting. For example, VMart.
TMPDIR
Directory for storing temporary files. The default is platform-dependent. On Unix-like systems the default is /tmp.
VSQL_EDITOR
EDITOR
VISUAL
Editor used by the \e command. The variables are examined in the order listed; the first that is set is used.
VSQL_HOME
By default, the vsql program reads configuration files from the user's home directory. In cases where this is not desirable, the configuration file location can be overridden by setting the VSQL_HOME environment variable in a way that does not require modifying a shared resource.
VSQL_HOST
Host name or IP address of the Vertica node.
VSQL_PASSWORD
The database password. Using this environment variable increases site security by precluding the need to enter the database password on the command line.
VSQL_PORT
Port to use for the connection.
VSQL_SSLMODE
Specifies whether and how clients such as admintools use SSL when connecting to servers.
VSQL_USER
User name to use for the connection.