Postgres::getFtsDictionaryTemplates PHP Метод

getFtsDictionaryTemplates() публичный Метод

Returns all FTS dictionary templates available
    function getFtsDictionaryTemplates()
    {
        $sql = "\n \t\t\tSELECT\n\t\t\t\tn.nspname as schema,\n\t\t\t\tt.tmplname as name,\n\t\t\t\t( SELECT COALESCE(np.nspname, '(null)')::pg_catalog.text || '.' || p.proname\n\t\t\t\t\tFROM pg_catalog.pg_proc p\n\t\t\t\t\tLEFT JOIN pg_catalog.pg_namespace np ON np.oid = p.pronamespace\n\t\t\t\t\tWHERE t.tmplinit = p.oid ) AS  init,\n\t\t\t\t( SELECT COALESCE(np.nspname, '(null)')::pg_catalog.text || '.' || p.proname\n\t\t\t\t\tFROM pg_catalog.pg_proc p\n\t\t\t\t\tLEFT JOIN pg_catalog.pg_namespace np ON np.oid = p.pronamespace\n\t\t\t\t\tWHERE t.tmpllexize = p.oid ) AS  lexize,\n\t\t\t\tpg_catalog.obj_description(t.oid, 'pg_ts_template') as comment\n\t\t\tFROM pg_catalog.pg_ts_template t\n\t\t\t\tLEFT JOIN pg_catalog.pg_namespace n ON n.oid = t.tmplnamespace\n\t\t\tWHERE pg_catalog.pg_ts_template_is_visible(t.oid)\n\t\t\tORDER BY name;";
        return $this->selectSet($sql);
    }
Postgres