Skip to main content

Environment variables

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()
name type references description
"schema" VARCHAR   The schema in which the session variable is created
"name" VARCHAR   The declared name for the variable. The combination of schema and name uniquely identifies a specific variable.
"type" VARCHAR   The data type of the variable.
"value" VARCHAR   The value (as string) for the variable in the current session.
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.