Skip site navigation (1) Skip section navigation (2)

Re: psql \conninfo command (was: Patch: psql \whoami option)

From: David Christensen <david(at)endpoint(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Steve Singer <ssinger_pg(at)sympatico(dot)ca>, pgsql-hackers Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: psql \conninfo command (was: Patch: psql \whoami option)
Date: 2010-07-20 03:41:47
Message-ID: (view raw or whole thread)
Lists: pgsql-hackers
On Jul 19, 2010, at 10:34 PM, Robert Haas wrote:

> On Sun, Jul 18, 2010 at 2:00 PM, David Christensen <david(at)endpoint(dot)com> wrote:
>> Updated the commitfest entry with the patch, updated the title to reflect the actual name of the command, and marked as ready for committer.
> I took a look at this patch.  One problem is that it doesn't handle
> the case where there is no database connection (for example, shut down
> the database with pg_ctl, then do select 1, then do \conninfo).  I've
> fixed that in the attached version.

Thanks, I hadn't considered that case.

> However, I'm also wondering about the output format.  I feel like it
> would make sense to use a format similar to what we do for \c, which
> looks like this:
> You are now connected to database "%s".
> It prints out more parameters if they've changed.  The longest
> possible version is:
> You are now connected to database "%s" on host "%s" at port "%s" as user "%s".
> My suggestion is that we use the same format, except (1) always
> include all the components, since that's the point; (2) don't include
> the word "now"; and (3) if there is no host, then print "via local
> socket" rather than on host...port....  So where the current patch
> prints:
> Connected to database: "rhaas", user: "rhaas", port: 5432 via local
> domain socket
> I would propose to print instead:
> You are connected to database "rhaas" via local socket as user "rhaas".
> If people strongly prefer the way the patch does it now, I don't think
> it's horrible... but it seems like it would be nicer to be somewhat
> consistent with the existing message.  Thoughts?

+1 from me; I don't care what color the bikeshed is, as long as it gets the point across, which this does, and is consistent to boot.


David Christensen
End Point Corporation

In response to


pgsql-hackers by date

Next:From: Robert HaasDate: 2010-07-20 03:54:19
Subject: pgsql: Add \conninfo command to psql, to show current connection info.
Previous:From: Robert HaasDate: 2010-07-20 03:40:07
Subject: Re: Explicit psqlrc

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group