Postgres::getFtsDictionaryByName PHP Method

getFtsDictionaryByName() public method

Return all information relating to a FTS dictionary
public getFtsDictionaryByName ( $ftsdict ) : RecordSet
$ftsdict The name of the FTS dictionary
return RecordSet of FTS dictionary information
    function getFtsDictionaryByName($ftsdict)
    {
        $c_schema = $this->_schema;
        $this->clean($c_schema);
        $this->clean($ftsdict);
        $sql = "SELECT\n\t\t\t   n.nspname as schema,\n\t\t\t   d.dictname as name,\n\t\t\t   ( SELECT COALESCE(nt.nspname, '(null)')::pg_catalog.text || '.' || t.tmplname FROM\n\t\t\t\t pg_catalog.pg_ts_template t\n\t\t\t\t\t\t\t\t\t  LEFT JOIN pg_catalog.pg_namespace nt ON nt.oid = t.tmplnamespace\n\t\t\t\t\t\t\t\t\t  WHERE d.dicttemplate = t.oid ) AS  template,\n\t\t\t   d.dictinitoption as init,\n\t\t\t   pg_catalog.obj_description(d.oid, 'pg_ts_dict') as comment\n\t\t\tFROM pg_catalog.pg_ts_dict d\n\t\t\t\tLEFT JOIN pg_catalog.pg_namespace n ON n.oid = d.dictnamespace\n\t\t\tWHERE d.dictname = '{$ftsdict}'\n\t\t\t   AND pg_catalog.pg_ts_dict_is_visible(d.oid)\n\t\t\t   AND n.nspname='{$c_schema}'\n\t\t\tORDER BY name";
        return $this->selectSet($sql);
    }
Postgres