From 5e60c542c52059cdcdb8a7a2b1cec561f43f7a66 Mon Sep 17 00:00:00 2001 From: jian he Date: Thu, 28 Mar 2024 10:45:15 +0800 Subject: [PATCH v6 2/2] make psql \dD displays the domain's basetype. previously psql \dD only shows the type that the domain is based on. now add a column to display the primitive basetye (that's not a domain) of a domain. --- src/bin/psql/describe.c | 2 ++ 1 file changed, 2 insertions(+) diff --git a/src/bin/psql/describe.c b/src/bin/psql/describe.c index 6433497b..34fcaef8 100644 --- a/src/bin/psql/describe.c +++ b/src/bin/psql/describe.c @@ -4444,6 +4444,7 @@ listDomains(const char *pattern, bool verbose, bool showSystem) "SELECT n.nspname as \"%s\",\n" " t.typname as \"%s\",\n" " pg_catalog.format_type(t.typbasetype, t.typtypmod) as \"%s\",\n" + " pg_catalog.pg_basetype(t.typbasetype) as \"%s\",\n" " (SELECT c.collname FROM pg_catalog.pg_collation c, pg_catalog.pg_type bt\n" " WHERE c.oid = t.typcollation AND bt.oid = t.typbasetype AND t.typcollation <> bt.typcollation) as \"%s\",\n" " CASE WHEN t.typnotnull THEN 'not null' END as \"%s\",\n" @@ -4454,6 +4455,7 @@ listDomains(const char *pattern, bool verbose, bool showSystem) gettext_noop("Schema"), gettext_noop("Name"), gettext_noop("Type"), + gettext_noop("Basetype"), gettext_noop("Collation"), gettext_noop("Nullable"), gettext_noop("Default"), -- 2.34.1