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);
}