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/[email protected]
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
psql_constraints.patch
Description: Binary data
-- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
