BUG #4670: Cannot get domain constraint names from psql

The following bug has been logged online:

Bug reference: 4670
Logged by: Alexander V. Chernikov
Email address: melifaro@ipfw.ru
PostgreSQL version: 8.3.3
Operating system: FreeBSD 7.1
Description: Cannot get domain constraint names from psql
Details:

It would be nice to see domain constraint names in \dD output of psql
utility. Without this feature the only way to delete (or modify) constraint
is to do pg_dump -s (or use something like phpgadmin) to find out constraint
name and only after that issue ALTER DOMAIN .. DROP constraint statement.
Patch for adding this functionality is quite trivial, for example:

--- bin/psql/describe.c.orig    2009-02-22 02:58:23.000000000 +0300
+++ bin/psql/describe.c 2009-02-22 03:05:54.000000000 +0300
@@ -1628,6 +1628,7 @@
                                          "            WHEN NOT t.typnotnull
AND t.typdefault IS NOT NULL THEN 'default '||t.typdefault\n"
                                          "            ELSE ''\n"
                                          "       END as \"%s\",\n"
+                                         "       r.conname as \"%s\",\n"
                        "       pg_catalog.pg_get_constraintdef(r.oid, true)
as \"%s\"\n"
                                          "FROM pg_catalog.pg_type t\n"
           "     LEFT JOIN pg_catalog.pg_namespace n ON n.oid =
t.typnamespace\n"
@@ -1637,6 +1638,7 @@
                                          _("Name"),
                                          _("Type"),
                                          _("Modifier"),
+                                         _("Constraint_name"),
                                          _("Check"));

processSQLNamePattern(pset.db, &buf, pattern, true, false,