Have psql \dD show checks - Mailing list pgsql-patches

From Greg Sabino Mullane
Subject Have psql \dD show checks
Date
Msg-id 2d99ac070b7b5c5a98f035f7e13c0f08@biglumber.com
Whole thread Raw
Responses Re: Have psql \dD show checks
List pgsql-patches
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Patch to show check information when listing domains via \dD in psql.
Per question by Edmund Bacon on the pgsql-general list.

- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200504030911
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iD8DBQFCT+t8vJuQZxSWSsgRAog3AJwOp8ac7xvgQ1lt2sDTu2hwAr63hwCfYz2T
GqxgS3t64mF4Vn8Ie5n8hvo=
=a1GE
-----END PGP SIGNATURE-----


Index: describe.c
===================================================================
RCS file: /projects/cvsroot/pgsql/src/bin/psql/describe.c,v
retrieving revision 1.114
diff -c -r1.114 describe.c
*** describe.c    1 Apr 2005 05:30:38 -0000    1.114
--- describe.c    3 Apr 2005 13:07:14 -0000
***************
*** 1579,1592 ****
                        "            WHEN t.typnotnull AND t.typdefault IS NULL THEN 'not null'\n"
                        "            WHEN NOT t.typnotnull AND t.typdefault IS NOT NULL THEN 'default
'||t.typdefault\n"
                        "            ELSE ''\n"
!                       "       END as \"%s\"\n"
                        "FROM pg_catalog.pg_type t\n"
!     "     LEFT JOIN pg_catalog.pg_namespace n ON n.oid = t.typnamespace\n"
                        "WHERE t.typtype = 'd'\n",
                        _("Schema"),
                        _("Name"),
                        _("Type"),
!                       _("Modifier"));

      processNamePattern(&buf, pattern, true, false,
                         "n.nspname", "t.typname", NULL,
--- 1579,1595 ----
                        "            WHEN t.typnotnull AND t.typdefault IS NULL THEN 'not null'\n"
                        "            WHEN NOT t.typnotnull AND t.typdefault IS NOT NULL THEN 'default
'||t.typdefault\n"
                        "            ELSE ''\n"
!                       "       END as \"%s\",\n"
!                         "       pg_catalog.pg_get_constraintdef(r.oid, true) as \"%s\"\n"
                        "FROM pg_catalog.pg_type t\n"
!     "     JOIN pg_catalog.pg_namespace n ON n.oid = t.typnamespace\n"
!     "     LEFT JOIN pg_catalog.pg_constraint r ON t.oid = r.contypid\n"
                        "WHERE t.typtype = 'd'\n",
                        _("Schema"),
                        _("Name"),
                        _("Type"),
!                       _("Modifier"),
!                       _("Check"));

      processNamePattern(&buf, pattern, true, false,
                         "n.nspname", "t.typname", NULL,



pgsql-patches by date:

Previous
From: Dirk Raetzel
Date:
Subject: Re: [BUGS] BUG #1563: wrong week returnded by date_trunc('week',
Next
From: Neil Conway
Date:
Subject: Re: unused variable ShmemBootstrap