Commite6557e9

Neil Conway

committed

Include information about a domain's CHECK constraint, if any, in the

output of \dD in psql. From Greg Sabino Mullane.

1 parent00a1b1e commite6557e9Copy full SHA for e6557e9

File tree

-3

lines changed

-3

lines changed

Lines changed: 6 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -3,7 +3,7 @@`
`3`	`3`	`*`
`4`	`4`	`* Copyright (c) 2000-2005, PostgreSQL Global Development Group`
`5`	`5`	`*`
`6`		`- * $PostgreSQL: pgsql/src/bin/psql/describe.c,v 1.114 2005/04/01 05:30:38 momjian Exp $`
	`6`	`+ * $PostgreSQL: pgsql/src/bin/psql/describe.c,v 1.115 2005/04/06 05:23:32 neilc Exp $`
`7`	`7`	`*/`
`8`	`8`	`#include"postgres_fe.h"`
`9`	`9`	`#include"describe.h"`
`@@ -1579,14 +1579,17 @@ listDomains(const char *pattern)`
`1579`	`1579`	`" WHEN t.typnotnull AND t.typdefault IS NULL THEN 'not null'\n"`
`1580`	`1580`	`" WHEN NOT t.typnotnull AND t.typdefault IS NOT NULL THEN 'default '\|\|t.typdefault\n"`
`1581`	`1581`	`" ELSE ''\n"`
`1582`		`-" END as \"%s\"\n"`
	`1582`	`+" END as \"%s\",\n"`
	`1583`	`+" pg_catalog.pg_get_constraintdef(r.oid, true) as \"%s\"\n"`
`1583`	`1584`	`"FROM pg_catalog.pg_type t\n"`
`1584`	`1585`	`" LEFT JOIN pg_catalog.pg_namespace n ON n.oid = t.typnamespace\n"`
	`1586`	`+" LEFT JOIN pg_catalog.pg_constraint r ON t.oid = r.contypid\n"`
`1585`	`1587`	`"WHERE t.typtype = 'd'\n",`
`1586`	`1588`	`_("Schema"),`
`1587`	`1589`	`_("Name"),`
`1588`	`1590`	`_("Type"),`
`1589`		`-_("Modifier"));`
	`1591`	`+_("Modifier"),`
	`1592`	`+_("Check"));`
`1590`	`1593`
`1591`	`1594`	`processNamePattern(&buf,pattern, true, false,`
`1592`	`1595`	`"n.nspname","t.typname",NULL,`

Comments

(0)