Postgres::getView PHP Method

getView() public method

Returns all details for a particular view
public getView ( $view ) : View
$view The name of the view to retrieve
return View info
    function getView($view)
    {
        $c_schema = $this->_schema;
        $this->clean($c_schema);
        $this->clean($view);
        $sql = "\n\t\t\tSELECT c.relname, n.nspname, pg_catalog.pg_get_userbyid(c.relowner) AS relowner,\n\t\t\t\tpg_catalog.pg_get_viewdef(c.oid, true) AS vwdefinition,\n\t\t\t\tpg_catalog.obj_description(c.oid, 'pg_class') AS relcomment\n\t\t\tFROM pg_catalog.pg_class c\n\t\t\t\tLEFT JOIN pg_catalog.pg_namespace n ON (n.oid = c.relnamespace)\n\t\t\tWHERE (c.relname = '{$view}') AND n.nspname='{$c_schema}'";
        return $this->selectSet($sql);
    }
Postgres