| From: | Pavel Luzanov <p(dot)luzanov(at)postgrespro(dot)ru> |
|---|---|
| To: | Maiquel Grassi <grassi(at)hotmail(dot)com(dot)br>, Nathan Bossart <nathandbossart(at)gmail(dot)com> |
| Cc: | Erik Wienhold <ewie(at)ewie(dot)name>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Psql meta-command conninfo+ |
| Date: | 2024-02-07 12:35:34 |
| Message-ID: | 852cabef-f596-4826-9a54-d3f75d9a6cc8@postgrespro.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
This is a good idea about extended connection info.
On 07.02.2024 07:13, Maiquel Grassi wrote:
> SELECT
> ...
> current_user AS "User",
This will be inconsistent with \conninfo.
\conninfo returns authenticated user (PQuser), not the current_user.
It might be worth showing current_user, session_user, and authenticated user,
but I can't find the appropriate sql function for PQuser.
What about to include system_user function? It shows useful authentication details.
Also, it seems that the verbose parameter in the listConnectionInformation
is unnecessary.
--
Pavel Luzanov
Postgres Professional:https://postgrespro.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2024-02-07 12:37:29 | Re: Commitfest 2024-01 first week update |
| Previous Message | shveta malik | 2024-02-07 12:01:50 | Re: Synchronizing slots from primary to standby |