Postgres::getTableParents PHP Method

getTableParents() public method

Finds the names and schemas of parent tables (in order)
public getTableParents ( $table ) : A
$table The table to find the parents for
return A recordset
    function getTableParents($table)
    {
        $c_schema = $this->_schema;
        $this->clean($c_schema);
        $this->clean($table);
        $sql = "\n\t\t\tSELECT\n\t\t\t\tpn.nspname, relname\n\t\t\tFROM\n\t\t\t\tpg_catalog.pg_class pc, pg_catalog.pg_inherits pi, pg_catalog.pg_namespace pn\n\t\t\tWHERE\n\t\t\t\tpc.oid=pi.inhparent\n\t\t\t\tAND pc.relnamespace=pn.oid\n\t\t\t\tAND pi.inhrelid = (SELECT oid from pg_catalog.pg_class WHERE relname='{$table}'\n\t\t\t\t\tAND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = '{$c_schema}'))\n\t\t\tORDER BY\n\t\t\t\tpi.inhseqno\n\t\t";
        return $this->selectSet($sql);
    }
Postgres