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?
>
> The same issue is in TEMP tables, but we can determine them by their
> schema; they are always created in pg_temp_N schema.
I believe it is in the "title" of the table presented by \d (Table,
Unlogged table, Temp table)
--
Cédric Villemain 2ndQuadrant
http://2ndQuadrant.fr/ PostgreSQL : Expertise, Formation et Support