diff options
| author | Teodor Sigaev <teodor@sigaev.ru> | 2017-03-28 18:58:55 +0300 |
|---|---|---|
| committer | Teodor Sigaev <teodor@sigaev.ru> | 2017-03-28 18:58:55 +0300 |
| commit | ab89e465cb2032017c4888399f47a76ac16eaf40 (patch) | |
| tree | ba20a87318e5c036744d0ecaaa388b4a05941b7f /src/bin/psql/describe.c | |
| parent | 85163641f8bdeb7734b37ae67faa224a029afe25 (diff) | |
| download | postgresql-ab89e465cb2032017c4888399f47a76ac16eaf40.tar.gz postgresql-ab89e465cb2032017c4888399f47a76ac16eaf40.zip | |
Altering default privileges on schemas
Extend ALTER DEFAULT PRIVILEGES command to schemas.
Author: Matheus Oliveira
Reviewed-by: Petr Jelínek, Ashutosh Sharma
https://commitfest.postgresql.org/13/887/
Diffstat (limited to 'src/bin/psql/describe.c')
| -rw-r--r-- | src/bin/psql/describe.c | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/src/bin/psql/describe.c b/src/bin/psql/describe.c index bcf675208b4..b0f3e5e3470 100644 --- a/src/bin/psql/describe.c +++ b/src/bin/psql/describe.c @@ -1028,7 +1028,7 @@ 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 '%c' THEN '%s' WHEN '%c' THEN '%s' WHEN '%c' THEN '%s' WHEN '%c' 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' WHEN '%c' THEN '%s' END AS \"%s\",\n" " ", gettext_noop("Owner"), gettext_noop("Schema"), @@ -1040,6 +1040,8 @@ listDefaultACLs(const char *pattern) gettext_noop("function"), DEFACLOBJ_TYPE, gettext_noop("type"), + DEFACLOBJ_NAMESPACE, + gettext_noop("schema"), gettext_noop("Type")); printACLColumn(&buf, "d.defaclacl"); |