Re: [COMMITTERS] pgsql: Add \conninfo command to psql, to show current connection info. - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [COMMITTERS] pgsql: Add \conninfo command to psql, to show current connection info.
Date
Msg-id 23611.1280857566@sss.pgh.pa.us
Whole thread Raw
Responses Re: [COMMITTERS] pgsql: Add \conninfo command to psql, to show current connection info.
Re: [COMMITTERS] pgsql: Add \conninfo command to psql, to show current connection info.
List pgsql-hackers
rhaas@postgresql.org (Robert Haas) writes:
> Add \conninfo command to psql, to show current connection info.
> David Christensen. Reviewed by Steve Singer.  Some further changes by me.

Looking at the output from this command:

regression=# \conninfo 
You are connected to database "regression" via local socket in "/tmp" at port "5432" as user "postgres".

This seems a bit awkwardly phrased.  I think it would read better if the
ordering was changed to

You are connected to database "regression" as user "postgres" via local socket in "/tmp" at port "5432".

I can't put my finger on the reason why the current ordering seems like
awkward English, but I can give a couple of concrete arguments for
changing it:

1. This way would match the argument ordering for \connect,
which in case you've forgotten is dbname user host port.

2. At least to me, this seems closer to the relative importance of the
items.

Comments, objections?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Boszormenyi Zoltan
Date:
Subject: Re: ECPG dynamic cursor fix for UPDATE/DELETE ... WHERE CURRENT OF :curname
Next
From: "Kevin Grittner"
Date:
Subject: Re: [COMMITTERS] pgsql: Add \conninfo command to psql, to show current connection info.