Re: [GENERAL] Temporary tables and miscellaneous schemas - Mailing list pgsql-patches

From Sean Chittenden
Subject Re: [GENERAL] Temporary tables and miscellaneous schemas
Date
Msg-id 20031222033545.GA33747@perrin.nxad.com
Whole thread Raw
In response to Re: [GENERAL] Temporary tables and miscellaneous schemas  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-patches
> > I think the original complaint was misguided and we should not do
> > anything about it.  IIRC the complaint amounted to "I have
> > hundreds of schemas and it annoys me that \dn shows them all".
> > How is this different from putting hundreds of tables into one
> > schema and then being annoyed because \dt shows them all?  We have
> > other mechanisms available for making \dn selective (ie, you can
> > use a name pattern).  If \dn is restricted to showing only schemas
> > in your search path, it will become useless.
>
> I completely agree.  It's like saying that \l should only show
> databases you are currently connected to...

For the record and if Tom was referring to me, the example I gave was
to have \dn show all schemas that you have any permissions for, not
that were in the search path.  -sc

--
Sean Chittenden

pgsql-patches by date:

Previous
From: Zach Irmen
Date:
Subject: Re: psql \i handling ~ in specified file name
Next
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] Temporary tables and miscellaneous schemas