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: E1T8YWB-0003PV-5U@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/c1f3c045cdc97fc74e571d4e8705f7dbe7e1ec8b

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

Browse pgsql-committers by date

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