Re: Who am I? Where am I connected?

On Wed, May 18, 2022 at 5:43 PM David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Wed, May 18, 2022 at 3:08 AM Dominique Devienne <ddevienne(at)gmail(dot)com>
> wrote:
>
>> Once connected, can I find out all aspects of the connection string?
>> Or where they came from, like a pgpass.conf or service file?
>>
>> How to get the host, port, db name once connected?
>> SHOW and pg_settings does not appear to be it, at first glance.
>>
>>
> The server has no clue how the values sent to it came into existence - nor
> should it.
>
> Whether and how any particular client might expose this kind of debugging
> information (or upgrade it to proper state info) is up to the client. I do
> not know what options psql offers.
>

AFAIK, it’s not psql that does this though, it’s libpq the official client
api.
And the fact libpq has no way to surface that info seems like an important
oversight.

>