The following bug has been logged online:
Bug reference: 4547
Logged by: Ferdinand Gassauer
Email address: gassauer@kde.org
PostgreSQL version: 8.3.5
Operating system: any
Description: sort columns in \d
Details:
currently the columns are sorted by attnum (not very userfriendly) instead
of attname (userfriendly)
this patch fixes this and makes the output of \d much more usable.
thank you for listening
--- describe.c.dist 2008-11-23 16:59:07.000000000 +0100
+++ describe.c 2008-11-23 16:59:28.000000000 +0100
@@ -867,7 +867,7 @@ describeOneTableDetails(const char *sche
appendPQExpBuffer(&buf, "\nWHERE a.attrelid = '%s' AND a.attnum > 0
AND NOT a.attisdropped", oid);
if (tableinfo.relkind == 'i')
appendPQExpBuffer(&buf, " AND a.attrelid = i.indexrelid");
- appendPQExpBuffer(&buf, "\nORDER BY a.attnum");
+ appendPQExpBuffer(&buf, "\nORDER BY a.attname");
res = PSQLexec(buf.data, false);
if (!res)
