author | Oleksandr Gavenko <gavenkoa@gmail.com> |
Tue, 10 Dec 2019 19:34:24 +0200 | |
changeset 2392 | eddb9a8153b5 |
parent 2391 | aedbd074ec54 |
child 2393 | 6f68472e27d9 |
postgres.rst | file | annotate | diff | comparison | revisions |
--- 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 ===========