2011/2/22 Itagaki Takahiro <itagaki.takah...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers