Re: Temp table visibility

On Fri, Aug 05, 2011 at 08:35:37AM -0400, JJ wrote:
> Hello all,
>
> I was recently looking at the way "create temp table as" works and the manual specifies that temp tables given the same name as an existing table will be used instead of the permanent table. It also states that the permanent table can be accessed via its schema-qualified name. I may have answered my own question but is there any way to emulate this table visibility functionality when referencing tables by their schema-qualified name?
> --

No, because the schema qualification is what makes for the visibility
functionality. To draw an analogy, suppose your $PATH includes
/usr/bin but not /usr/local/bin, and that you have two psql binaries,
one in /usr/bin and one in /usr/local/bin. If you type psql, you get
the one in /usr/bin. If you type /usr/local/bin/psql, you always get
that one, even though it's not in the $PATH. The $PATH doesn't affect
the visibility of the string |psql|, just adds an implicit way of
finding such a string if it's on the path somewhere.

A

--
Andrew Sullivan
ajs(at)crankycanuck(dot)ca