diff options
| author | Simon Riggs | 2017-11-22 18:17:47 +0000 |
|---|---|---|
| committer | Simon Riggs | 2017-11-22 18:17:47 +0000 |
| commit | 3bae43ca4dc6c3123788044436521f1d33d9f930 (patch) | |
| tree | fc4ff430a499639746a1f7c0a6f545f78c530b38 /src/bin/psql | |
| parent | 05b6ec39d72f7065bb5ce770319e826f1da92441 (diff) | |
Sort default partition to bottom of psql \d+
Minor patch to change sort order only
Author: Ashutosh Bapat
Reviewed-by: Álvaro Herrera, Simon Riggs
Diffstat (limited to 'src/bin/psql')
| -rw-r--r-- | src/bin/psql/describe.c | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/src/bin/psql/describe.c b/src/bin/psql/describe.c index 44c508971a0..99167104d44 100644 --- a/src/bin/psql/describe.c +++ b/src/bin/psql/describe.c @@ -2875,7 +2875,8 @@ describeOneTableDetails(const char *schemaname, " c.relkind" " FROM pg_catalog.pg_class c, pg_catalog.pg_inherits i" " WHERE c.oid=i.inhrelid AND i.inhparent = '%s'" - " ORDER BY c.oid::pg_catalog.regclass::pg_catalog.text;", oid); + " ORDER BY pg_catalog.pg_get_expr(c.relpartbound, c.oid) = 'DEFAULT'," + " c.oid::pg_catalog.regclass::pg_catalog.text;", oid); else if (pset.sversion >= 80300) printfPQExpBuffer(&buf, "SELECT c.oid::pg_catalog.regclass" |