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

Re: Patch: psql \whoami option

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: Martin Atukunda <matlads(at)gmail(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>, David Christensen <david(at)endpoint(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Patch: psql \whoami option
Date: 2010-01-27 16:39:39
Message-ID: 8054.1264610379@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Magnus Hagander <magnus(at)hagander(dot)net> writes:
> 2010/1/27 Martin Atukunda <matlads(at)gmail(dot)com>:
>> How about using the psql prompt to convey this information?

> I think the idea is that if you do that, it'll be there all the time,
> potentially "crowding the space".

I had the same reaction as Martin.  If you want this info all the time,
setting the prompt is the way to go.  If you only want it occasionally,
you're probably more likely to remember other ways of getting the info
first (session_user, pg_stat_activity, etc etc).  There may be some
use-case in between where another backslash command would be helpful,
but it seems a tad marginal to me.  I don't object as long as it's not
overdesigned, but let's keep the bells and whistles to a minimum.

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Tim BunceDate: 2010-01-27 16:40:19
Subject: Re: Add on_perl_init and proper destruction to plperl [PATCH]
Previous:From: Heikki LinnakangasDate: 2010-01-27 16:38:00
Subject: Re: testing cvs HEAD - HS/SR - missing file

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