Hello, the march 2008 commitfest added a patch[1] with extended information for \l+. The may 2008 commitfest added a patch[2] which reformats the permission output in \z. I like the new output in \z, but the \l+ output is still missing this feature. The attached patch solves this problem.
Kind regards 1: http://archives.postgresql.org/message-id/488c2fe3-a6c7-4cfa-bd3c-f0588da81...@tcpd.net 2: http://archives.postgresql.org/message-id/37ed240d0804170921h7a6b92fev65aeb99f658f8...@mail.gmail.com -- Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board of Directors
*** src/bin/psql/describe.c 2008-12-21 13:19:40.000000000 +0100 --- src/bin/psql/describe.c.orig 2008-12-21 02:16:31.000000000 +0100 *************** *** 464,476 **** " d.datctype as \"%s\",\n", gettext_noop("Collation"), gettext_noop("Ctype")); ! if (pset.sversion >= 80100) ! appendPQExpBuffer(&buf, ! " pg_catalog.array_to_string(d.datacl, E'\\n') as \"%s\"", ! gettext_noop("Access Privileges")); ! else ! appendPQExpBuffer(&buf, ! " pg_catalog.array_to_string(d.datacl, '\\n') as \"%s\"", gettext_noop("Access Privileges")); if (verbose && pset.sversion >= 80200) appendPQExpBuffer(&buf, --- 464,471 ---- " d.datctype as \"%s\",\n", gettext_noop("Collation"), gettext_noop("Ctype")); ! appendPQExpBuffer(&buf, ! " d.datacl as \"%s\"", gettext_noop("Access Privileges")); if (verbose && pset.sversion >= 80200) appendPQExpBuffer(&buf,
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers