Re: UNLOGGED tables in psql \d

From: Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com>
To: Itagaki Takahiro <itagaki(dot)takahiro(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: UNLOGGED tables in psql \d
Date: 2011-02-22 09:11:49
Message-ID: AANLkTi=_trNXmDrnm9hYLPKtwtOO3+aGUWjRarSD=XDP@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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?
>
> 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2011-02-22 10:09:48 Re: Sync Rep v17
Previous Message Marti Raudsepp 2011-02-22 08:59:21 Re: Sync Rep v17