Re: UNLOGGED tables in psql \d

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?
- The head characters of the second words would be small letters.
We describe other objects as "Composite type", "Foreign table", or so.

--
Itagaki Takahiro