Re: UNLOGGED tables in psql \d - Mailing list pgsql-hackers

From Itagaki Takahiro
Subject Re: UNLOGGED tables in psql \d
Date
Msg-id AANLkTi=3fjUtZfFqU8a45vv-43c_tCPqYsCGjX6wA7Ek@mail.gmail.com
Whole thread Raw
In response to Re: UNLOGGED tables in psql \d  (Cédric Villemain <cedric.villemain.debian@gmail.com>)
Responses Re: UNLOGGED tables in psql \d  (Cédric Villemain <cedric.villemain.debian@gmail.com>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Sync Rep v17
Next
From: Robert Haas
Date:
Subject: Re: Void binary patch