> Tom Lane wrote:
> > Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > > How about if we add a UNION that does:
> > > UNION
> > > SELECT 'non-local temp schemas skipped', NULL
> > I think showing that would only be appropriate if we actually *did* skip
> > some. Finding that out would complicate the query unduly IMHO.
> > > I see a few goals here:
> > > Prevent \dn from showing lots of lines for large installs
> > > Show the local temp schema so people can query it
> > If those are agreed to be the goals then we end up with your original
> > solution (or a working implementation of same anyway).
> > I'd like to see some input from other people about what they want...
> I have added this to the TODO list:
> * Have psql \dn show only visible schemas using current_schemas()
> I know there was talk of showing all schemas only in admin mode, but I
> don't think we want to implement different behavior until we have a more
> practical reason to have such a mode distiction. Of course, \dn will
> have to be documented that is supresses non-visible schemas, and admins
> can always do a select from pg_namespace.
This patch uses current_schemas('true') to display only the schemas in
the current search path and implicit schemas.
It uses an array with =ANY(), which we already do in psql's describe.c
for groups. I also had to use :: for casting because that's the only
way to cast function parameters, I think.
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
pgsql-hackers by date
|Next:||From: Christopher Browne||Date: 2003-12-21 04:30:57|
|Subject: Re: [pgsql-advocacy] PostgreSQL speakers needed for OSCON 2004|
|Previous:||From: Tom Lane||Date: 2003-12-21 03:54:13|
|Subject: Re: [HACKERS] PostgreSQL speakers needed for OSCON 2004 |
pgsql-patches by date
|Next:||From: Zach Irmen||Date: 2003-12-21 04:33:02|
|Subject: psql \i handling ~ in specified file name|
|Previous:||From: Tom Lane||Date: 2003-12-20 19:11:29|
|Subject: Re: pgsql-server/ oc/src/sgml/datatype.sgml rc/bac ... |