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

Re: psql backslash consistency

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Greg Sabino Mullane <greg(at)turnstep(dot)com>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: psql backslash consistency
Date: 2005-05-30 14:26:14
Message-ID: 200505301426.j4UEQEG09913@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-patches
Greg Sabino Mullane wrote:
[ There is text before PGP section. ]
> 
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> 
> > Could we have a way to turn this off?  At least for functions and
> > operators?  For my usage, at least, this will be a serious step
> > backwards in usefulness
> 
> But all we are asking is that you add a single letter ('S') to your
> queries. There are probably only a handful of people besides yourself
> who use \df to look up system functions, while the other 99% of the world
> would benefit greatly from being able to do a \df and see their functions,
> as opposed to doing "\df public.*" (which won't work of course if you have
> your functions in other schemas).

I am thinking we need a non-system modifier like U (user) that will only
show only user functions, operators, etc.  With that, we can default the
backslash commands to be the most convenient default, and it can be
over-ridden.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-patches by date

Next:From: Bruce MomjianDate: 2005-05-30 14:28:17
Subject: Re: Escape handling in COPY, strings, psql
Previous:From: Greg Sabino MullaneDate: 2005-05-30 14:22:39
Subject: Re: psql backslash consistency

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