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. |