| From: | Dominique Devienne <ddevienne(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Who am I? Where am I connected? |
| Date: | 2022-05-18 10:07:47 |
| Message-ID: | CAFCRh-_BSW8VRPPQU6OrKmLZmk1+-0GvbBObgkMmqWf2_YqMkQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
LibPQ has various defaults for the host, user, and DB name.
There's also the password file, the service file and service name.
In the example below, I can connect with a "naked" psql invocation.
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.
Thanks, --DD
c:\Users\ddevienne>psql
psql (12.1, server 14.2)
WARNING: psql major version 12, server major version 14.
Some psql features might not work.
WARNING: Console code page (437) differs from Windows code page (1252)
8-bit characters might not work correctly. See psql reference
page "Notes for Windows users" for details.
Type "help" for help.
ddevienne=>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Erik Wienhold | 2022-05-18 10:29:34 | Re: Who am I? Where am I connected? |
| Previous Message | David G. Johnston | 2022-05-18 01:50:11 | Re: Restricting user to see schema structure |