After running into the need twice now - is there a particular reason why we don't have psql showing the owner of a type, at least in \dT+?
If not, how about attached trivial patch? -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/
*** a/src/bin/psql/describe.c --- b/src/bin/psql/describe.c *************** *** 533,538 **** describeTypes(const char *pattern, bool verbose, bool showSystem) --- 533,544 ---- printACLColumn(&buf, "t.typacl"); appendPQExpBufferStr(&buf, ",\n "); } + if (verbose) + { + appendPQExpBuffer(&buf, + " pg_catalog.pg_get_userbyid(t.typowner) AS \"%s\",\n", + gettext_noop("Owner")); + } appendPQExpBuffer(&buf, " pg_catalog.obj_description(t.oid, 'pg_type') as \"%s\"\n",
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers