On Wed, May 18, 2022 at 5:43 PM David G. Johnston < david.g.johns...@gmail.com> wrote:
> On Wed, May 18, 2022 at 3:08 AM Dominique Devienne <ddevie...@gmail.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. >
