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)

See Also

Setting a Client Connection Label