diff --git a/src/bin/psql/describe.c b/src/bin/psql/describe.c index 67a2b47..a6ee4ab 100644 *** a/src/bin/psql/describe.c --- b/src/bin/psql/describe.c *************** describeOneTableDetails(const char *sche *** 1591,1598 **** /* Label as primary key or unique (but not both) */ if (strcmp(PQgetvalue(result, i, 1), "t") == 0) appendPQExpBuffer(&buf, " PRIMARY KEY,"); ! else if (strcmp(PQgetvalue(result, i, 2), "t") == 0) ! appendPQExpBuffer(&buf, " UNIQUE,"); /* Everything after "USING" is echoed verbatim */ indexdef = PQgetvalue(result, i, 5); --- 1591,1602 ---- /* Label as primary key or unique (but not both) */ if (strcmp(PQgetvalue(result, i, 1), "t") == 0) appendPQExpBuffer(&buf, " PRIMARY KEY,"); ! else if (strcmp(PQgetvalue(result, i, 2), "t") == 0) { ! if (verbose && strcmp(PQgetvalue(result, i, 7), "u") == 0) ! appendPQExpBuffer(&buf, " UNIQUE CONSTRAINT,"); ! else ! appendPQExpBuffer(&buf, " UNIQUE,"); ! } /* Everything after "USING" is echoed verbatim */ indexdef = PQgetvalue(result, i, 5);