postgres.rst
changeset 2392 eddb9a8153b5
parent 2391 aedbd074ec54
child 2393 6f68472e27d9
--- a/postgres.rst	Tue Dec 10 19:31:15 2019 +0200
+++ b/postgres.rst	Tue Dec 10 19:34:24 2019 +0200
@@ -68,6 +68,19 @@
 
    SELECT * FROM pg_available_extensions;
 
+Set application name
+====================
+
+``application_name`` is displayed in ``pg_stat_activity.application_name``.
+
+It can help identify clients of DB. To alter it in current session::
+
+  SET application_name = 'some name';
+
+To show current value::
+
+  SHOW application_name;
+
 Limitations
 ===========