> On 06/06/2023 09:18 CEST Hrishikesh (Richie) Rode <hr...@livevox.com> wrote: > > We are not able to find table which give session connection details about > drivers. In pg_stat_activity details information is not there. Please let us > know where we can find these information.
Column pg_stat_activity.application_name is the only one I know of that may provide such details. But it relies on the driver setting application_name when connecting. Some drivers set a default, e.g. pgjdbc, but also allow overriding with a custom application name that may include additional info such as driver version. But in the end application_name is just text without any inherent structure. -- Erik
