diff options
| author | Heikki Linnakangas <heikki.linnakangas@iki.fi> | 2013-01-25 17:19:11 +0200 |
|---|---|---|
| committer | Heikki Linnakangas <heikki.linnakangas@iki.fi> | 2013-01-25 17:22:26 +0200 |
| commit | 89368676273a4455a20eea61b8c2f30190a223ec (patch) | |
| tree | 9f8a71ec4da68741757d918d9d97941fbe7dbf75 /src/bin | |
| parent | 7441b49d1930a56b20c8ab4bb3ecb9bcdb4878de (diff) | |
| download | postgresql-89368676273a4455a20eea61b8c2f30190a223ec.tar.gz postgresql-89368676273a4455a20eea61b8c2f30190a223ec.zip | |
Add prosecdef to \df+ output.
Jon Erdman, reviewed by Phil Sorber and Stephen Frost.
Diffstat (limited to 'src/bin')
| -rw-r--r-- | src/bin/psql/describe.c | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/src/bin/psql/describe.c b/src/bin/psql/describe.c index 87174cc9197..8064a3d7024 100644 --- a/src/bin/psql/describe.c +++ b/src/bin/psql/describe.c @@ -256,7 +256,7 @@ describeFunctions(const char *functypes, const char *pattern, bool verbose, bool " WHEN p.proiswindow THEN '%s'\n" " WHEN p.prorettype = 'pg_catalog.trigger'::pg_catalog.regtype THEN '%s'\n" " ELSE '%s'\n" - "END as \"%s\"", + " END as \"%s\"", gettext_noop("Result data type"), gettext_noop("Argument data types"), /* translator: "agg" is short for "aggregate" */ @@ -330,15 +330,19 @@ describeFunctions(const char *functypes, const char *pattern, bool verbose, bool if (verbose) appendPQExpBuffer(&buf, + ",\n CASE WHEN prosecdef THEN '%s' ELSE '%s' END AS \"%s\"" ",\n CASE\n" " WHEN p.provolatile = 'i' THEN '%s'\n" " WHEN p.provolatile = 's' THEN '%s'\n" " WHEN p.provolatile = 'v' THEN '%s'\n" - "END as \"%s\"" + " END as \"%s\"" ",\n pg_catalog.pg_get_userbyid(p.proowner) as \"%s\",\n" " l.lanname as \"%s\",\n" " p.prosrc as \"%s\",\n" " pg_catalog.obj_description(p.oid, 'pg_proc') as \"%s\"", + gettext_noop("definer"), + gettext_noop("invoker"), + gettext_noop("Security"), gettext_noop("immutable"), gettext_noop("stable"), gettext_noop("volatile"), |