diff options
Diffstat (limited to 'src/bin/psql/psql.c')
| -rw-r--r-- | src/bin/psql/psql.c | 12 |
1 files changed, 11 insertions, 1 deletions
diff --git a/src/bin/psql/psql.c b/src/bin/psql/psql.c index 331960753d1..5ded4548284 100644 --- a/src/bin/psql/psql.c +++ b/src/bin/psql/psql.c @@ -7,7 +7,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/bin/psql/Attic/psql.c,v 1.110 1997/11/17 17:54:24 momjian Exp $ + * $Header: /cvsroot/pgsql/src/bin/psql/Attic/psql.c,v 1.111 1997/11/17 22:14:55 momjian Exp $ * *------------------------------------------------------------------------- */ @@ -1686,6 +1686,7 @@ HandleSlashCmds(PsqlSettings *pset, break; case 'd': /* \d describe database information */ if (strncmp(cmd, "da", 2) == 0) + { /* aggregates */ SendQuery(&success, pset,"\ SELECT a.aggname AS aggname, \ @@ -1695,6 +1696,15 @@ HandleSlashCmds(PsqlSettings *pset, WHERE a.aggbasetype = t.oid \ ORDER BY aggname, typname;", false, false, 0); + SendQuery(&success, pset,"\ + SELECT a.aggname AS aggname, \ + 'all types' as all_types, \ + obj_description(a.oid) as description \ + FROM pg_aggregate a \ + WHERE a.aggbasetype = 0 \ + ORDER BY aggname;", + false, false, 0); + } else if (strncmp(cmd, "dd", 2) == 0) /* descriptions */ objectDescription(pset, optarg+1, NULL); |