Re: UNLOGGED tables in psql \d

On Tue, Feb 22, 2011 at 18:11, Cédric Villemain
<cedric.villemain.debian@gmail.com> wrote:
> 2011/2/22 Itagaki Takahiro <itagaki.takahiro@gmail.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",
"Foreigntable", or so. 

--
Itagaki Takahiro