From: | Steve Atkins <steve(at)blighty(dot)com> |
---|---|
To: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Connection type |
Date: | 2018-01-18 16:19:10 |
Message-ID: | 4F75C783-571E-4091-B343-4A14AFD14E1E@blighty.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> On Jan 18, 2018, at 4:06 PM, Enrico Pirozzi <e(dot)pirozzi(at)nbsgroup(dot)it> wrote:
>
> Hi,
>
> is there a way to know what kind of connection a client is doing? (ODBC,JDBC..etc)
>
> I saw the pg_stat_activity view,
>
>
> but in the application name field there no infomation about
> what kind of connection a client is doing.
No. They're all exactly the same as far as postgresql is concerned all speaking the
same postgresql native protocol, or close enough. The ODBC / JDBC / libpq difference
is purely on the client side.
A client can voluntarily set the application_name, e.g. as part of it's connection string,
to identify itself to the server, if you want to be able to identify which sort of client
is connected easily.
Cheers,
Steve
From | Date | Subject | |
---|---|---|---|
Next Message | Abhra Kar | 2018-01-18 16:22:32 | Call sql function in psql |
Previous Message | Don Seiler | 2018-01-18 16:11:46 | Could not read block in file |