RE: Psql meta-command conninfo+
От
Maiquel Grassi
Тема
RE: Psql meta-command conninfo+
Дата
Msg-id
CP8P284MB24965479BA59DF5C2CC01CA0EC462@CP8P284MB2496.BRAP284.PROD.OUTLOOK.COM
Ответ на
Re: Psql meta-command conninfo+ (Nathan Bossart)
Список
Дерево обсуждения
Psql meta-command conninfo+ Maiquel Grassi <grassi@hotmail.com.br>
Re: Psql meta-command conninfo+ Nathan Bossart <nathandbossart@gmail.com>
Re: Psql meta-command conninfo+ Erik Wienhold <ewie@ewie.name>
RE: Psql meta-command conninfo+ Maiquel Grassi <grassi@hotmail.com.br>
Re: Psql meta-command conninfo+ Nathan Bossart <nathandbossart@gmail.com>
Re: Psql meta-command conninfo+ Nathan Bossart <nathandbossart@gmail.com>
RE: Psql meta-command conninfo+ Maiquel Grassi <grassi@hotmail.com.br>
Re: Psql meta-command conninfo+ Nathan Bossart <nathandbossart@gmail.com>
RE: Psql meta-command conninfo+ Maiquel Grassi <grassi@hotmail.com.br>
Re: Psql meta-command conninfo+ Erik Wienhold <ewie@ewie.name>
RE: Psql meta-command conninfo+ Maiquel Grassi <grassi@hotmail.com.br>
Re: Psql meta-command conninfo+ Pavel Luzanov <p.luzanov@postgrespro.ru>
RE: Psql meta-command conninfo+ Maiquel Grassi <grassi@hotmail.com.br>
Re: Psql meta-command conninfo+ Pavel Luzanov <p.luzanov@postgrespro.ru>
RE: Psql meta-command conninfo+ Maiquel Grassi <grassi@hotmail.com.br>
Re: Psql meta-command conninfo+ Jim Jones <jim.jones@uni-muenster.de>
RE: Psql meta-command conninfo+ Maiquel Grassi <grassi@hotmail.com.br>
Re: Psql meta-command conninfo+ Jim Jones <jim.jones@uni-muenster.de>
RE: Psql meta-command conninfo+ Maiquel Grassi <grassi@hotmail.com.br>
Re: Psql meta-command conninfo+ Erik Wienhold <ewie@ewie.name>
RE: Psql meta-command conninfo+ Maiquel Grassi <grassi@hotmail.com.br>
Re: Psql meta-command conninfo+ Alvaro Herrera <alvherre@alvh.no-ip.org>
RE: Psql meta-command conninfo+ Maiquel Grassi <grassi@hotmail.com.br>
RE: Psql meta-command conninfo+ Maiquel Grassi <grassi@hotmail.com.br>
Re: Psql meta-command conninfo+ Jim Jones <jim.jones@uni-muenster.de>
RE: Psql meta-command conninfo+ Maiquel Grassi <grassi@hotmail.com.br>
Re: Psql meta-command conninfo+ Nathan Bossart <nathandbossart@gmail.com>
Re: Psql meta-command conninfo+ Jim Jones <jim.jones@uni-muenster.de>
RE: Psql meta-command conninfo+ Maiquel Grassi <grassi@hotmail.com.br>
RE: Psql meta-command conninfo+ Maiquel Grassi <grassi@hotmail.com.br>
Re: Psql meta-command conninfo+ Pavel Luzanov <p.luzanov@postgrespro.ru>
RE: Psql meta-command conninfo+ Maiquel Grassi <grassi@hotmail.com.br>
Re: Psql meta-command conninfo+ Pavel Luzanov <p.luzanov@postgrespro.ru>
RE: Psql meta-command conninfo+ Maiquel Grassi <grassi@hotmail.com.br>
Re: Psql meta-command conninfo+ Jim Jones <jim.jones@uni-muenster.de>
RE: Psql meta-command conninfo+ Maiquel Grassi <grassi@hotmail.com.br>
RE: Psql meta-command conninfo+ Maiquel Grassi <grassi@hotmail.com.br>
Re: Psql meta-command conninfo+ Jim Jones <jim.jones@uni-muenster.de>
Re: Psql meta-command conninfo+ Nathan Bossart <nathandbossart@gmail.com>
RE: Psql meta-command conninfo+ Maiquel Grassi <grassi@hotmail.com.br>
Re: Psql meta-command conninfo+ Nathan Bossart <nathandbossart@gmail.com>
RE: Psql meta-command conninfo+ Maiquel Grassi <grassi@hotmail.com.br>
Re: Psql meta-command conninfo+ Nathan Bossart <nathandbossart@gmail.com>
RE: Psql meta-command conninfo+ Maiquel Grassi <grassi@hotmail.com.br>
RE: Psql meta-command conninfo+ Maiquel Grassi <grassi@hotmail.com.br>
Re: Psql meta-command conninfo+ "Imseih (AWS), Sami" <simseih@amazon.com>
RE: Psql meta-command conninfo+ Maiquel Grassi <grassi@hotmail.com.br>
Re: Psql meta-command conninfo+ "Imseih (AWS), Sami" <simseih@amazon.com>
RE: Psql meta-command conninfo+ Maiquel Grassi <grassi@hotmail.com.br>
Re: Psql meta-command conninfo+ Alvaro Herrera <alvherre@alvh.no-ip.org>
RE: Psql meta-command conninfo+ Maiquel Grassi <grassi@hotmail.com.br>
Re: Psql meta-command conninfo+ Alvaro Herrera <alvherre@alvh.no-ip.org>
RE: Psql meta-command conninfo+ Maiquel Grassi <grassi@hotmail.com.br>
Re: Psql meta-command conninfo+ Alvaro Herrera <alvherre@alvh.no-ip.org>
RE: Psql meta-command conninfo+ Maiquel Grassi <grassi@hotmail.com.br>
Re: Psql meta-command conninfo+ "Imseih (AWS), Sami" <simseih@amazon.com>
RE: Psql meta-command conninfo+ Maiquel Grassi <grassi@hotmail.com.br>
Re: Psql meta-command conninfo+ "Imseih (AWS), Sami" <simseih@amazon.com>
RE: Psql meta-command conninfo+ Maiquel Grassi <grassi@hotmail.com.br>
Re: Psql meta-command conninfo+ Peter Eisentraut <peter@eisentraut.org>
Re: Psql meta-command conninfo+ Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: Psql meta-command conninfo+ "Imseih (AWS), Sami" <simseih@amazon.com>
RE: Psql meta-command conninfo+ Maiquel Grassi <grassi@hotmail.com.br>
Re: Psql meta-command conninfo+ Tom Lane <tgl@sss.pgh.pa.us>
RE: Psql meta-command conninfo+ Maiquel Grassi <grassi@hotmail.com.br>
Re: Psql meta-command conninfo+ Peter Eisentraut <peter@eisentraut.org>
Re: Psql meta-command conninfo+ "Imseih (AWS), Sami" <simseih@amazon.com>
RE: Psql meta-command conninfo+ Maiquel Grassi <grassi@hotmail.com.br>
Re: Psql meta-command conninfo+ Nathan Bossart <nathandbossart@gmail.com>
RE: Psql meta-command conninfo+ Maiquel Grassi <grassi@hotmail.com.br>
Re: Psql meta-command conninfo+ Hunaid Sohail <hunaidpgml@gmail.com>
Re: Psql meta-command conninfo+ Jim Jones <jim.jones@uni-muenster.de>
RE: Psql meta-command conninfo+ Maiquel Grassi <grassi@hotmail.com.br>
RE: Psql meta-command conninfo+ Maiquel Grassi <grassi@hotmail.com.br>
Re: Psql meta-command conninfo+ "Imseih (AWS), Sami" <simseih@amazon.com>
Re: Psql meta-command conninfo+ "Imseih (AWS), Sami" <simseih@amazon.com>
RE: Psql meta-command conninfo+ Maiquel Grassi <grassi@hotmail.com.br>
Re: Psql meta-command conninfo+ Nathan Bossart <nathandbossart@gmail.com>
RE: Psql meta-command conninfo+ Maiquel Grassi <grassi@hotmail.com.br>
RE: Psql meta-command conninfo+ Maiquel Grassi <grassi@hotmail.com.br>
Re: Psql meta-command conninfo+ Pavel Luzanov <p.luzanov@postgrespro.ru>
RE: Psql meta-command conninfo+ Maiquel Grassi <grassi@hotmail.com.br>
RE: Psql meta-command conninfo+ Maiquel Grassi <grassi@hotmail.com.br>
On Tue, Feb 06, 2024 at 03:06:05PM -0600, Nathan Bossart wrote:
> On Tue, Feb 06, 2024 at 08:52:09PM +0000, Maiquel Grassi wrote:
>> I made the adjustment in the code and updated the patch. I believe this
>> is the format suggested by you all. Would this be it?
>
> I was thinking something more like
>
> SELECT pg_catalog.current_database() AS "Database",
> current_user AS "User",
> pg_catalog.current_setting('server_version') AS "Server Version",
> pg_catalog.inet_server_addr() AS "Server Address",
> pg_catalog.current_setting('port') AS "Port",
> pg_catalog.inet_client_addr() AS "Client Address",
> pg_catalog.inet_client_port() AS "Client Port",
> pg_catalog.pg_backend_pid() AS "Session PID";
... although that seems to be missing items like the socket directory and
the host.
--//--
> On Tue, Feb 06, 2024 at 08:52:09PM +0000, Maiquel Grassi wrote:
>> I made the adjustment in the code and updated the patch. I believe this
>> is the format suggested by you all. Would this be it?
>
> I was thinking something more like
>
> SELECT pg_catalog.current_database() AS "Database",
> current_user AS "User",
> pg_catalog.current_setting('server_version') AS "Server Version",
> pg_catalog.inet_server_addr() AS "Server Address",
> pg_catalog.current_setting('port') AS "Port",
> pg_catalog.inet_client_addr() AS "Client Address",
> pg_catalog.inet_client_port() AS "Client Port",
> pg_catalog.pg_backend_pid() AS "Session PID";
... although that seems to be missing items like the socket directory and
the host.
--//--
My initial idea has always been that they should continue to appear because \conninfo+ should show all the things that \conninfo shows and add more information. I think that's the purpose of the 'plus.' Now we're on a better path than the initial one. We can still add the socket directory and the host.
Regards,
Maiquel O. Grassi.
В списке pgsql-hackers по дате отправления
