Re: UNLOGGED tables in psql \d

2011/2/22 Itagaki Takahiro <itagaki(dot)takahiro(at)gmail(dot)com>:
> On Tue, Feb 22, 2011 at 18:11, Cédric Villemain
> <cedric(dot)villemain(dot)debian(at)gmail(dot)com> wrote:
>> 2011/2/22 Itagaki Takahiro <itagaki(dot)takahiro(at)gmail(dot)com>:
>>> psql \d(+) doesn't show any information about UNLOGGED and TEMP attributes
>>> for the table. So, we cannot know the table is unlogged or not unless
>>> we directly select from pg_class.relpersistence.  Is this a TODO item?
>>
>> I believe it is in the "title" of the table presented by \d (Table,
>> Unlogged table, Temp table)
>
> Ah, I see. Thank you.  They are shown as "Unlogged Table" and
> "Unlogged Index".
>
> - We don't have "Temp" for temp tables. Should we have?

Hum, First, I would say yes to be more consistent with the unlogged
case, but 2nd we must refrain from outputting too much information
where it is not relevant.

The fact that you didn''t saw it might be enough to reconsider the way
we display the unlogged state (and temp state) of a relation.

Maybe some a "Durability: normal, temp, unlogged" line at bottom of
the \d output ?

> - The head characters of the second words would be small letters.
>  We describe other objects as "Composite type", "Foreign table", or so.
>
> --
> Itagaki Takahiro
>

--
Cédric Villemain               2ndQuadrant
http://2ndQuadrant.fr/     PostgreSQL : Expertise, Formation et Support