From 22cd3f7aa4614ee70957f419b09df983af07af67 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Thu, 20 Oct 2005 05:15:09 +0000 Subject: [PATCH] Make \d order a table's check constraints by constraint name instead of the text of the constraint condition. Per Chris K-L, though I didn't use his patch exactly. --- src/bin/psql/describe.c | 9 ++++----- 1 file changed, 4 insertions(+), 5 deletions(-) diff --git a/src/bin/psql/describe.c b/src/bin/psql/describe.c index 8735ded235..96ab5e50e4 100644 --- a/src/bin/psql/describe.c +++ b/src/bin/psql/describe.c @@ -1036,9 +1036,8 @@ describeOneTableDetails(const char *schemaname, if (tableinfo.checks) { printfPQExpBuffer(&buf, - "SELECT " - "pg_catalog.pg_get_constraintdef(r.oid, true), " - "conname\n" + "SELECT r.conname, " + "pg_catalog.pg_get_constraintdef(r.oid, true)\n" "FROM pg_catalog.pg_constraint r\n" "WHERE r.conrelid = '%s' AND r.contype = 'c' ORDER BY 1", oid); @@ -1192,8 +1191,8 @@ describeOneTableDetails(const char *schemaname, for (i = 0; i < check_count; i++) { printfPQExpBuffer(&buf, _(" \"%s\" %s"), - PQgetvalue(result2, i, 1), - PQgetvalue(result2, i, 0)); + PQgetvalue(result2, i, 0), + PQgetvalue(result2, i, 1)); footers[count_footers++] = pg_strdup(buf.data); } -- 2.39.5