phpPgAdmin

You can turn on aggreagates with the advanced objects setting in the config.inc.php

    // Display "advanced" objects? Setting this to true will show
    // aggregates, types, operators, operator classes, conversions,
    // languages and casts in phpPgAdmin. These objects are rarely
    // administered and can clutter the interface.
    $conf['show_advanced'] = false;