Re: Why schema of table is removed from explain? - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject Re: Why schema of table is removed from explain?
Date
Msg-id 20110901204251.GA23649@depesz.com
Whole thread Raw
In response to Why schema of table is removed from explain?  (hubert depesz lubaczewski <depesz@depesz.com>)
List pgsql-general
On Thu, Sep 01, 2011 at 04:39:06PM -0400, Tom Lane wrote:
> hubert depesz lubaczewski <depesz@depesz.com> writes:
> > On Thu, Sep 01, 2011 at 04:24:59PM -0400, Tom Lane wrote:
> >> The non-plain-text output formats provide that sort of detail, if you
> >> need it.
>
> > Which is great, but why can't we have it in plain text too?
>
> It's frequently unnecessary, and horizontal space is precious in the
> plain-text format.

Well, I understand that adding "public." usually wouldn't be any good,
but what about representing the table name as oid::regclass does? i.e.
adds schema only if table is in schema that is not in search_path?

Best regards,

depesz

--
The best thing about modern society is how easy it is to avoid contact with it.
                                                             http://depesz.com/

pgsql-general by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: Why schema of table is removed from explain?
Next
From: Raghavendra
Date:
Subject: pgfoundry.org is not accessible