SET_CLIENT_LABEL
Assigns a label to a client connection for the current session. You can use this label to distinguish client connections.
Labels appear in the v_monitor.sessions table. However, they are not updated in Data Collector tables because the change occurs after Vertica makes the connection.
Syntax
SET_CLIENT_LABEL('label‑name')
Parameters
label‑name |
VARCHAR name assigned to the client connection label. |
Privileges
None
Examples
Assign label data_load_application
to the current client connection:
=> SELECT SET_CLIENT_LABEL('data_load_application'); SET_CLIENT_LABEL ------------------------------------------- client_label set to data_load_application (1 row)