Postgres::getIndexes PHP Method

    function getIndexes($table = '', $unique = false)
    {
        $this->clean($table);
        $sql = "\n\t\t\tSELECT c2.relname AS indname, i.indisprimary, i.indisunique, i.indisclustered,\n\t\t\t\tpg_catalog.pg_get_indexdef(i.indexrelid, 0, true) AS inddef\n\t\t\tFROM pg_catalog.pg_class c, pg_catalog.pg_class c2, pg_catalog.pg_index i\n\t\t\tWHERE c.relname = '{$table}' AND pg_catalog.pg_table_is_visible(c.oid)\n\t\t\t\tAND c.oid = i.indrelid AND i.indexrelid = c2.oid\n\t\t";
        if ($unique) {
            $sql .= " AND i.indisunique ";
        }
        $sql .= " ORDER BY c2.relname";
        return $this->selectSet($sql);
    }