Environment variables

Environment variables mk Fri, 03/29/2013 - 15:30

The system keeps a small table of global variables, initialized upon system restart, session restart, or declared explicitly by the user.

sys.environment
name type references description
"name" VARCHAR   The unique identifying name of the global environment variable, such as monet_version and monet_release.
"value" VARCHAR   The value (as string) for the environment variable of the current instance of MonetDB.
sys.var_values
name type references description
"var_name" VARCHAR   The unique identifying name of the system session variable, such as current_schema, optimizer or last_id.
"value" VARCHAR   The value (as string) for the system variable of the current session.
sys.keywords
name type references description
"keyword" VARCHAR   The reserved SQL keyword.