From 5033095abb3631bf01e4213752d5a4d3a24896fa Mon Sep 17 00:00:00 2001 From: Justin Pryzby Date: Thu, 6 Jan 2022 20:25:07 -0600 Subject: [PATCH 2/3] psql: order a relation's extended statistics by name.. like \dX not by OID v15 only? --- src/bin/psql/describe.c | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/src/bin/psql/describe.c b/src/bin/psql/describe.c index b3fbff1a0c3..daf06bbcc81 100644 --- a/src/bin/psql/describe.c +++ b/src/bin/psql/describe.c @@ -2608,7 +2608,7 @@ describeOneTableDetails(const char *schemaname, printfPQExpBuffer(&buf, "SELECT oid, " "stxrelid::pg_catalog.regclass, " - "stxnamespace::pg_catalog.regnamespace AS nsp, " + "stxnamespace::pg_catalog.regnamespace::pg_catalog.text AS nsp, " "stxname,\n" "pg_catalog.pg_get_statisticsobjdef_columns(oid) AS columns,\n" " 'd' = any(stxkind) AS ndist_enabled,\n" @@ -2617,7 +2617,7 @@ describeOneTableDetails(const char *schemaname, "stxstattarget\n" "FROM pg_catalog.pg_statistic_ext stat\n" "WHERE stxrelid = '%s'\n" - "ORDER BY 1;", + "ORDER BY nsp, stxname;", oid); result = PSQLexec(buf.data); -- 2.17.1