From 9d66116444b9763bc09defb688fb09343420e040 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Sat, 29 Mar 2014 19:00:11 -0400 Subject: psql: display "Replica Identity" only for FULL and NOTHING INDEX is already displayed on the index, and we now exclude pg_catalog. DEFAULT is not displayed. --- src/bin/psql/describe.c | 9 ++++++--- 1 file changed, 6 insertions(+), 3 deletions(-) (limited to 'src/bin') diff --git a/src/bin/psql/describe.c b/src/bin/psql/describe.c index 21bbdf823a..d1447fe723 100644 --- a/src/bin/psql/describe.c +++ b/src/bin/psql/describe.c @@ -2345,16 +2345,19 @@ describeOneTableDetails(const char *schemaname, printTableAddFooter(&cont, buf.data); } - if (verbose && (tableinfo.relkind == 'r' || tableinfo.relkind == 'm') && + if ((tableinfo.relkind == 'r' || tableinfo.relkind == 'm') && + /* + * No need to display default values; we already display a + * REPLICA IDENTITY marker on indexes. + */ + tableinfo.relreplident != 'd' && tableinfo.relreplident != 'i' && strcmp(schemaname, "pg_catalog") != 0) { const char *s = _("Replica Identity"); printfPQExpBuffer(&buf, "%s: %s", s, - tableinfo.relreplident == 'd' ? "DEFAULT" : tableinfo.relreplident == 'f' ? "FULL" : - tableinfo.relreplident == 'i' ? "USING INDEX" : tableinfo.relreplident == 'n' ? "NOTHING" : "???"); -- cgit v1.2.1