Postgres::getFtsConfigurations PHP Method

getFtsConfigurations() public method

Returns available FTS configurations
public getFtsConfigurations ( $all = true ) : A
$all if false, returns schema qualified FTS confs
return A recordset
    function getFtsConfigurations($all = true)
    {
        $c_schema = $this->_schema;
        $this->clean($c_schema);
        $sql = "\n\t\t\tSELECT\n\t\t\t\tn.nspname as schema,\n\t\t\t\tc.cfgname as name,\n\t\t\t\tpg_catalog.obj_description(c.oid, 'pg_ts_config') as comment\n\t\t\tFROM\n\t\t\t\tpg_catalog.pg_ts_config c\n\t\t\t\tJOIN pg_catalog.pg_namespace n ON n.oid = c.cfgnamespace\n\t\t\tWHERE\n\t\t\t\tpg_catalog.pg_ts_config_is_visible(c.oid)";
        if (!$all) {
            $sql .= " AND  n.nspname='{$c_schema}'\n";
        }
        $sql .= "ORDER BY name";
        return $this->selectSet($sql);
    }
Postgres