Re: EXPLAIN omits schema?

Stephen Frost wrote:
> * Dave Page (dpage(at)postgresql(dot)org) wrote:
>> /* We only show the rel name, not schema name */
>> relname = get_rel_name(rte->relid);
>>
>> Anyone know why? This seems like a bug to me given the ambiguity of
>> possible output.
>
> I'd assume it's to keep the explain output smaller with the
> expectation/assumption that in general you're going to know. A possible
> work-around would be to just always provide table aliases for your
> queries, as those are shown in the explain.

I am hoping that once we have WITH RECURSIVE, we could optionally
provide a normalized dump into a table of the EXPLAIN output, that could
then be easily "connected" the the old output using WITH RECURSIVE.

regards,
Lukas