From 1180431bbae5d7df995bd374b4130d1a3d712c74 Mon Sep 17 00:00:00 2001 From: Andrew Dunstan Date: Mon, 5 May 2008 00:11:31 +0000 Subject: [PATCH] Show enum values in psql's \dt+. David Fetter. --- src/bin/psql/describe.c | 17 ++++++++++++++--- 1 file changed, 14 insertions(+), 3 deletions(-) diff --git a/src/bin/psql/describe.c b/src/bin/psql/describe.c index 7e58580576..c0ed189df2 100644 --- a/src/bin/psql/describe.c +++ b/src/bin/psql/describe.c @@ -307,11 +307,22 @@ describeTypes(const char *pattern, bool verbose) " WHEN t.typlen < 0\n" " THEN CAST('var' AS pg_catalog.text)\n" " ELSE CAST(t.typlen AS pg_catalog.text)\n" - " END AS \"%s\",\n", + " END AS \"%s\",\n" + " pg_catalog.array_to_string(\n" + " ARRAY(\n" + " SELECT e.enumlabel\n" + " FROM pg_catalog.pg_enum e\n" + " WHERE e.enumtypid = t.oid\n" + " ORDER BY e.oid\n" + " ),\n" + " E'\\n'\n" + " ) AS \"%s\",\n", gettext_noop("Internal name"), - gettext_noop("Size")); + gettext_noop("Size"), + gettext_noop("Elements")); + appendPQExpBuffer(&buf, - " pg_catalog.obj_description(t.oid, 'pg_type') as \"%s\"\n", + " pg_catalog.obj_description(t.oid, 'pg_type') as \"%s\"\n", gettext_noop("Description")); appendPQExpBuffer(&buf, "FROM pg_catalog.pg_type t\n" -- 2.39.5