diff options
Diffstat (limited to 'src/bin/psql/describe.c')
| -rw-r--r-- | src/bin/psql/describe.c | 11 |
1 files changed, 9 insertions, 2 deletions
diff --git a/src/bin/psql/describe.c b/src/bin/psql/describe.c index 15d02eeeff1..a1c31582fe6 100644 --- a/src/bin/psql/describe.c +++ b/src/bin/psql/describe.c @@ -14,6 +14,8 @@ #include <ctype.h> +#include "catalog/pg_default_acl.h" + #include "common.h" #include "describe.h" #include "dumputils.h" @@ -774,7 +776,7 @@ permissionsList(const char *pattern) /* * \ddp * - * List DefaultACLs. The pattern can match either schema or role name. + * List Default ACLs. The pattern can match either schema or role name. */ bool listDefaultACLs(const char *pattern) @@ -796,13 +798,18 @@ listDefaultACLs(const char *pattern) printfPQExpBuffer(&buf, "SELECT pg_catalog.pg_get_userbyid(d.defaclrole) AS \"%s\",\n" " n.nspname AS \"%s\",\n" - " CASE d.defaclobjtype WHEN 'r' THEN '%s' WHEN 'S' THEN '%s' WHEN 'f' THEN '%s' END AS \"%s\",\n" + " CASE d.defaclobjtype WHEN '%c' THEN '%s' WHEN '%c' THEN '%s' WHEN '%c' THEN '%s' WHEN '%c' THEN '%s' END AS \"%s\",\n" " ", gettext_noop("Owner"), gettext_noop("Schema"), + DEFACLOBJ_RELATION, gettext_noop("table"), + DEFACLOBJ_SEQUENCE, gettext_noop("sequence"), + DEFACLOBJ_FUNCTION, gettext_noop("function"), + DEFACLOBJ_TYPE, + gettext_noop("type"), gettext_noop("Type")); printACLColumn(&buf, "d.defaclacl"); |