Vertica Quick Tip: Setting a Client Connection Label

Posted February 14, 2018 by Soniya Shah, Information Developer

City in Blur Motion
This blog post was authored by Jim Knicely.

When you connect to a Vertica database you can set a client connection label to help you later identify the connection.

Example: dbadmin=> SELECT set_client_label('Daily Load'); set_client_label -------------------------------- client_label set to Daily Load (1 row) dbadmin=> SELECT get_client_label(); get_client_label ------------------ Daily Load (1 row) dbadmin=> SELECT client_label FROM sessions WHERE session_id = current_session(); client_label -------------- Daily Load (1 row) Have fun!