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

From Cédric Villemain
Subject Re: UNLOGGED tables in psql \d
Date
Msg-id AANLkTi=_trNXmDrnm9hYLPKtwtOO3+aGUWjRarSD=XDP@mail.gmail.com
Whole thread Raw
In response to UNLOGGED tables in psql \d  (Itagaki Takahiro <itagaki.takahiro@gmail.com>)
Responses Re: UNLOGGED tables in psql \d  (Itagaki Takahiro <itagaki.takahiro@gmail.com>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Marti Raudsepp
Date:
Subject: Re: Sync Rep v17
Next
From: Andres Freund
Date:
Subject: Re: Sync Rep v17