7
7
*
8
8
*
9
9
* IDENTIFICATION
10
- * $Header: /cvsroot/pgsql/src/bin/psql/Attic/psql.c,v 1.110 1997/11/1717:54:24 momjian Exp $
10
+ * $Header: /cvsroot/pgsql/src/bin/psql/Attic/psql.c,v 1.111 1997/11/1722:14:55 momjian Exp $
11
11
*
12
12
*-------------------------------------------------------------------------
13
13
*/
@@ -1686,6 +1686,7 @@ HandleSlashCmds(PsqlSettings *pset,
1686
1686
break ;
1687
1687
case 'd' :/* \d describe database information */
1688
1688
if (strncmp (cmd ,"da" ,2 )== 0 )
1689
+ {
1689
1690
/* aggregates */
1690
1691
SendQuery (& success ,pset ,"\
1691
1692
SELECTa.aggname AS aggname, \
@@ -1695,6 +1696,15 @@ HandleSlashCmds(PsqlSettings *pset,
1695
1696
WHEREa.aggbasetype = t.oid \
1696
1697
ORDER BY aggname, typname;" ,
1697
1698
false, false,0 );
1699
+ SendQuery (& success ,pset ,"\
1700
+ SELECTa.aggname AS aggname, \
1701
+ 'all types' as all_types, \
1702
+ obj_description(a.oid) as description \
1703
+ FROMpg_aggregate a \
1704
+ WHEREa.aggbasetype = 0 \
1705
+ ORDER BY aggname;" ,
1706
+ false, false,0 );
1707
+ }
1698
1708
else if (strncmp (cmd ,"dd" ,2 )== 0 )
1699
1709
/* descriptions */
1700
1710
objectDescription (pset ,optarg + 1 ,NULL );