Set Applicationname when using Postgres ODBC driver

Question

How can I set the application name when connection to Postgres with the psqLODBC driver?

You get the application name from pg_stat_activity.application_name.

I tried different Parameters in the connection string.

APP=...; application_name=...; APP_NAME=... in all different variations.

Nothings works and pg_stat_activity.application_name always returns an empty string.

Given that the documentation does not list a property for that: you could run set application_name = 'doev'; after the connection is established — user330315
– user330315, Commented Sep 11, 2018 at 11:37
No, the documentation has no hint. And I have no idea, how I can use 'set' in my environment. — testo
– testo, Commented Sep 11, 2018 at 14:47
thank you. After I found out, how to open a odbc connection by vba-code, I could use your solution. I think I will delete this question in some time. — testo
– testo, Commented Sep 12, 2018 at 7:46
application_name=... would be the correct syntax in a regular connection string , but those semicolons and upper-case letters must be a windows thing - what name are you trying to set? — Jasen
– Jasen, Commented Sep 12, 2018 at 7:47

user330315 · Accepted Answer · 2018-09-12 07:47:50Z

3

Once you have established a connection in your application, you can run a SQL statement to change the application_name dynamically.

set application_name = 'doev';

You run that just like any other statement (that does not return a result) with your programming language. But remember if you have turned off autocommit in your connection, you need to commit that SET statement. If you are running in autocommit mode, that is not necessary.

answered Sep 12, 2018 at 7:47

user330315

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Set Applicationname when using Postgres ODBC driver

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related