Re: Temporary tables and miscellaneous schemas - Mailing list pgsql-general

From Tom Lane
Subject Re: Temporary tables and miscellaneous schemas
Date
Msg-id 28722.1066075974@sss.pgh.pa.us
Whole thread Raw
In response to Re: Temporary tables and miscellaneous schemas  (Sean Chittenden <sean@chittenden.org>)
Responses Re: Temporary tables and miscellaneous schemas
List pgsql-general
Sean Chittenden <sean@chittenden.org> writes:
> Why wouldn't you want to hide pg_temp_*?

So you could see your own temp tables, for instance.

I dislike putting random restrictions on what the \d displays will show.
We have done this in the past (eg, \df doesn't show things it thinks are
I/O functions) and by and large it's been a mistake; I think it's
created more confusion than it's prevented.

I certainly don't think there is any justification for exposing pg_toast
if we are going to hide other "system" schemas.  There is no normal
reason for needing to access toast tables directly, and it's only an
implementation artifact that they have names at all.

            regards, tom lane

pgsql-general by date:

Previous
From: Sean Chittenden
Date:
Subject: Re: Temporary tables and miscellaneous schemas
Next
From: Sean Chittenden
Date:
Subject: Re: Temporary tables and miscellaneous schemas