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

Re: [GENERAL] Temporary tables and miscellaneous schemas

From: Sean Chittenden <sean(at)chittenden(dot)org>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>,PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>,btober(at)seaworthysys(dot)com
Subject: Re: [GENERAL] Temporary tables and miscellaneous schemas
Date: 2003-12-22 03:35:45
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackerspgsql-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

In response to

pgsql-hackers by date

Next:From: Marc G. FournierDate: 2003-12-22 04:14:57
Subject: 7.4.1 tag'd and bundled ...
Previous:From: Andrew DunstanDate: 2003-12-22 01:45:11
Subject: Re: [pgsql-advocacy] PostgreSQL speakers needed for OSCON

pgsql-patches by date

Next:From: Christopher Kings-LynneDate: 2003-12-22 06:21:59
Subject: cascading column drop to index predicates
Previous:From: My DejaDate: 2003-12-21 22:50:38
Subject: pgAdmin crashes when client_min_messages is set in postgresql.conf

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