77 *
88 *
99 * 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 $
1111 *
1212 *-------------------------------------------------------------------------
1313 */
@@ -1686,6 +1686,7 @@ HandleSlashCmds(PsqlSettings *pset,
16861686break ;
16871687case 'd' :/* \d describe database information */
16881688if (strncmp (cmd ,"da" ,2 )== 0 )
1689+ {
16891690/* aggregates */
16901691SendQuery (& success ,pset ,"\
16911692SELECTa.aggname AS aggname, \
@@ -1695,6 +1696,15 @@ HandleSlashCmds(PsqlSettings *pset,
16951696WHEREa.aggbasetype = t.oid \
16961697ORDER BY aggname, typname;" ,
16971698false, 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+ }
16981708else if (strncmp (cmd ,"dd" ,2 )== 0 )
16991709/* descriptions */
17001710objectDescription (pset ,optarg + 1 ,NULL );