On fre, 2010-09-24 at 14:42 -0400, Tom Lane wrote:
> How do we want to define "system" exactly? My original proposal was
> for bare \dn to hide the temp and toast schemas. If we consider that
> what it's hiding is "system" schemas then there's some merit to the
> idea that it should hide pg_catal
Tom Lane writes:
> In that case, in a fresh database you would *only* see "public".
> I'm not sure that I like this though. Comments?
I sure like it! I can't count how many time I would have wanted a
"cleaned out" \dn output.
Regards,
--
dim
--
Sent via pgsql-hackers mailing list (pgsql-hack
Peter Eisentraut writes:
> On sön, 2010-09-19 at 13:51 -0400, Tom Lane wrote:
>> Hmm. If we had a \dnS option, what I would sorta expect it to do is
>> show the "system" schemas pg_catalog and information_schema. The
>> toast
>> and temp schemas seem like a different category somehow. On the o
On sön, 2010-09-19 at 13:51 -0400, Tom Lane wrote:
> Hmm. If we had a \dnS option, what I would sorta expect it to do is
> show the "system" schemas pg_catalog and information_schema. The
> toast
> and temp schemas seem like a different category somehow. On the other
> hand, if we did it like th
Robert Haas writes:
> On Sat, Sep 18, 2010 at 6:35 PM, Robert Haas wrote:
>> On Sat, Sep 18, 2010 at 3:11 PM, Tom Lane wrote:
>>> This is at least inconsistent and at worst wildly misleading. ISTM
>>> we ought to adopt some combination of the following ideas:
>> I vote for this combination:
>>
On Sat, Sep 18, 2010 at 6:35 PM, Robert Haas wrote:
> On Sat, Sep 18, 2010 at 3:11 PM, Tom Lane wrote:
>> This is at least inconsistent and at worst wildly misleading. ISTM
>> we ought to adopt some combination of the following ideas:
>
> I vote for this combination:
>
>> 3. Don't show either pg
On Sat, Sep 18, 2010 at 3:11 PM, Tom Lane wrote:
> This is at least inconsistent and at worst wildly misleading. ISTM
> we ought to adopt some combination of the following ideas:
I vote for this combination:
> 3. Don't show either pg_temp_nn or pg_toast_temp_nn schemas, not even
> for the curre
psql's \dn command hides pg_temp_nn schemas, except for the current
backend's own temp schema (if any). However, when we added separate
pg_toast_temp_nn schemas for TOAST tables, \dn wasn't taught about that,
leading to such odd-looking output as this:
regression=# \dn
List of schemas
