diff options
| author | Neil Conway <neilc@samurai.com> | 2004-09-10 04:10:53 +0000 |
|---|---|---|
| committer | Neil Conway <neilc@samurai.com> | 2004-09-10 04:10:53 +0000 |
| commit | ae7ea1395cc386f4b6d19d88c4f66cd027a64266 (patch) | |
| tree | 0900b7fbaf7ad939b5816b53ac0839a54cf1b1fa /src/bin/psql/large_obj.c | |
| parent | 35e88b512e2518dbcb81f07af741e21d338f7237 (diff) | |
psql consistency fixes from Greg Sabino Mullane: have \df show schema and
name first, make sure \di+ shows description last, and make \dl SQL look
a little more standard.
Diffstat (limited to 'src/bin/psql/large_obj.c')
| -rw-r--r-- | src/bin/psql/large_obj.c | 9 |
1 files changed, 5 insertions, 4 deletions
diff --git a/src/bin/psql/large_obj.c b/src/bin/psql/large_obj.c index 15a352aff43..7c9b5609635 100644 --- a/src/bin/psql/large_obj.c +++ b/src/bin/psql/large_obj.c @@ -3,7 +3,7 @@ * * Copyright (c) 2000-2004, PostgreSQL Global Development Group * - * $PostgreSQL: pgsql/src/bin/psql/large_obj.c,v 1.33 2004/08/29 04:13:02 momjian Exp $ + * $PostgreSQL: pgsql/src/bin/psql/large_obj.c,v 1.34 2004/09/10 04:10:53 neilc Exp $ */ #include "postgres_fe.h" #include "large_obj.h" @@ -249,9 +249,10 @@ do_lo_list(void) printQueryOpt myopt = pset.popt; snprintf(buf, sizeof(buf), - "SELECT loid as \"ID\", pg_catalog.obj_description(loid, 'pg_largeobject') as \"%s\"\n" - "FROM (SELECT DISTINCT loid FROM pg_catalog.pg_largeobject) x\n" - "ORDER BY \"ID\"", + "SELECT loid as \"ID\",\n" + " pg_catalog.obj_description(loid, 'pg_largeobject') as \"%s\"\n" + "FROM (SELECT DISTINCT loid FROM pg_catalog.pg_largeobject) x\n" + "ORDER BY 1", gettext("Description")); res = PSQLexec(buf, false); |