Skip site navigation (1) Skip section navigation (2)

pgsql: Make psql's \d+ show reloptions for all relkinds.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Make psql's \d+ show reloptions for all relkinds.
Date: 2012-09-03 15:24:51
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-committers
Make psql's \d+ show reloptions for all relkinds.

Formerly it would only show them for relkinds 'r' and 'f' (plain tables
and foreign tables).  However, as of 9.2, views can also have reloptions,
namely security_barrier.  The relkind restriction seems pointless and
not at all future-proof, so just print reloptions whenever there are any.

In passing, make some cosmetic improvements to the code that pulls the
"tableinfo" fields out of the PGresult.

Noted and patched by Dean Rasheed, with adjustment for all relkinds by me.



Modified Files
src/bin/psql/describe.c |   37 ++++++++++++++++++-------------------
1 files changed, 18 insertions(+), 19 deletions(-)

pgsql-committers by date

Next:From: Magnus HaganderDate: 2012-09-03 16:06:29
Subject: Re: [COMMITTERS] pgsql: Make a cut at a major-features list for 9.2.
Previous:From: User SakamotomshDate: 2012-09-03 09:47:46
Subject: pgbulkload - pgbulkload: Updated regression tests for pgbulkload 3.1.2

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group