diff options
Diffstat (limited to 'src')
| -rw-r--r-- | src/bin/psql/describe.c | 21 |
1 files changed, 12 insertions, 9 deletions
diff --git a/src/bin/psql/describe.c b/src/bin/psql/describe.c index ddb3942e952..e7c3d738f38 100644 --- a/src/bin/psql/describe.c +++ b/src/bin/psql/describe.c @@ -2343,15 +2343,18 @@ describeOneTableDetails(const char *schemaname, if (pset.sversion >= 100000) { printfPQExpBuffer(&buf, - "SELECT oid, stanamespace::regnamespace AS nsp, staname, stakeys,\n" - " (SELECT pg_catalog.string_agg(pg_catalog.quote_ident(attname::text),', ') \n" - " FROM ((SELECT pg_catalog.unnest(stakeys) AS attnum) s\n" - " JOIN pg_catalog.pg_attribute a ON (starelid = a.attrelid AND\n" - "a.attnum = s.attnum AND not attisdropped))) AS columns,\n" - " (staenabled::char[] @> '{d}'::char[]) AS ndist_enabled,\n" - " (staenabled::char[] @> '{f}'::char[]) AS deps_enabled\n" - "FROM pg_catalog.pg_statistic_ext stat WHERE starelid = '%s'\n" - "ORDER BY 1;", + "SELECT oid, " + "stanamespace::pg_catalog.regnamespace AS nsp, " + "staname, stakeys,\n" + " (SELECT pg_catalog.string_agg(pg_catalog.quote_ident(attname),', ')\n" + " FROM pg_catalog.unnest(stakeys) s(attnum)\n" + " JOIN pg_catalog.pg_attribute a ON (starelid = a.attrelid AND\n" + " a.attnum = s.attnum AND NOT attisdropped)) AS columns,\n" + " (staenabled @> '{d}') AS ndist_enabled,\n" + " (staenabled @> '{f}') AS deps_enabled\n" + "FROM pg_catalog.pg_statistic_ext stat " + "WHERE starelid = '%s'\n" + "ORDER BY 1;", oid); result = PSQLexec(buf.data); |