Postgres::getOpClasses PHP Method

getOpClasses() public method

Gets all opclasses
public getOpClasses ( ) : A
return A recordset
    function getOpClasses()
    {
        $c_schema = $this->_schema;
        $this->clean($c_schema);
        $sql = "\n\t\t\tSELECT\n\t\t\t\tpa.amname, po.opcname,\n\t\t\t\tpo.opcintype::pg_catalog.regtype AS opcintype,\n\t\t\t\tpo.opcdefault,\n\t\t\t\tpg_catalog.obj_description(po.oid, 'pg_opclass') AS opccomment\n\t\t\tFROM\n\t\t\t\tpg_catalog.pg_opclass po, pg_catalog.pg_am pa, pg_catalog.pg_namespace pn\n\t\t\tWHERE\n\t\t\t\tpo.opcmethod=pa.oid\n\t\t\t\tAND po.opcnamespace=pn.oid\n\t\t\t\tAND pn.nspname='{$c_schema}'\n\t\t\tORDER BY 1,2\n\t\t\t";
        return $this->selectSet($sql);
    }
Postgres