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:
- PAGER - If the query results do not fit on the screen, they are piped through this command. Typical values are
more
orless
. The default is platform-dependent. The use of the pager can be disabled by using the \pset command. - 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. For more information, see VSQL_HOME.
- VSQL_HOST - Host name or IP address of the Vertica node.
- VSQL_PORT - Port to use for the connection.
- VSQL_USER - Username to use for the connection.
- 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_EDITOR, EDITOR and VISUAL - Editor used by the \e command. The variables are examined in the order listed; the first that is set is used.
- VSQL_SSLMODE - Specifies how (or whether) clients (like admintools) use SSL when connecting to servers. For more information, see VSQL_SSLMODE.
- TMPDIR - Directory for storing temporary files. The default is platform-dependant. On Unix-like systems the default is
/tmp
.