On Tue, 29 Apr 2025 at 19:22, "songjinzhou" <tsinghualucky912@foxmail.com> wrote:
> Dear hackers, here is a libpq function: PQapplicationname(), I think it may be of some use.
>
> Looking forward to your reply, thank you.
>
I believe the use cases for this are narrow.
Generally, clients set the application_name and then don't need to
retrieve it. Its primary use seems to be on the server-side, for
monitoring through pg_stat_activity.
Could you explain your use case?
Assuming we do require this functionality, should we then also consider
the interplay between application_name and fallback_application_name?
Additionally, if a SET application_name TO xxx command is issued during
a subsequent connection, will the appname field within the PGconn structure
be updated promptly?
--
Regrads,
Japin Li