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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-patches by date

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