Postgres::getFunction PHP Method

getFunction() public method

Returns all details for a particular function
public getFunction ( $function_oid ) : Function
return Function info
    function getFunction($function_oid)
    {
        $this->clean($function_oid);
        $sql = "\n\t\t\tSELECT\n\t\t\t\tpc.oid AS prooid, proname, \n\t\t\t\tpg_catalog.pg_get_userbyid(proowner) AS proowner,\n\t\t\t\tnspname as proschema, lanname as prolanguage, procost, prorows,\n\t\t\t\tpg_catalog.format_type(prorettype, NULL) as proresult, prosrc,\n\t\t\t\tprobin, proretset, proisstrict, provolatile, prosecdef,\n\t\t\t\tpg_catalog.oidvectortypes(pc.proargtypes) AS proarguments,\n\t\t\t\tproargnames AS proargnames,\n\t\t\t\tpg_catalog.obj_description(pc.oid, 'pg_proc') AS procomment,\n\t\t\t\tproconfig,\n\t\t\t\t(select array_agg( (select typname from pg_type pt\n\t\t\t\t\twhere pt.oid = p.oid) ) from unnest(proallargtypes) p)\n\t\t\t\tAS proallarguments,\n\t\t\t\tproargmodes\n\t\t\tFROM\n\t\t\t\tpg_catalog.pg_proc pc, pg_catalog.pg_language pl,\n\t\t\t\tpg_catalog.pg_namespace pn\n\t\t\tWHERE\n\t\t\t\tpc.oid = '{$function_oid}'::oid AND pc.prolang = pl.oid\n\t\t\t\tAND pc.pronamespace = pn.oid\n\t\t\t";
        return $this->selectSet($sql);
    }
Postgres