patch: Distinguish between unique indexes and unique constraints

Josh Kupershmidt <schmiddy@gmail.com>

From: Josh Kupershmidt <schmiddy@gmail.com>

To: pgsql-hackers@postgresql.org

Date: 2010-04-18T03:53:01Z

Lists: pgsql-hackers

Attachments

psql_constraints.patch (application/octet-stream) patch

Addressing TODO item "Distinguish between unique indexes and unique
constraints in \d+" for psql, and picking up from thread:
http://archives.postgresql.org/message-id/8780.1271187360@sss.pgh.pa.us

Attached is a simple patch which clarifies unique constraints with
"UNIQUE CONSTRAINT" in psql's \d+ description of a table. The
appearance of unique indexes is left as-is.

== Old \d+ display ==
Indexes:
    "name_uniq_constr" UNIQUE, btree (name)

== New \d+ display ==
Indexes:
    "name_uniq_constr" UNIQUE CONSTRAINT, btree (name)

Josh