Postgres::getTriggers PHP Method

getTriggers() public method

Grabs a list of triggers on a table
public getTriggers ( $table = '' ) : A
$table The name of a table whose triggers to retrieve
return A recordset
    function getTriggers($table = '')
    {
        $c_schema = $this->_schema;
        $this->clean($c_schema);
        $this->clean($table);
        $sql = "SELECT\n\t\t\t\tt.tgname, pg_catalog.pg_get_triggerdef(t.oid) AS tgdef,\n\t\t\t\tCASE WHEN t.tgenabled = 'D' THEN FALSE ELSE TRUE END AS tgenabled, p.oid AS prooid,\n\t\t\t\tp.proname || ' (' || pg_catalog.oidvectortypes(p.proargtypes) || ')' AS proproto,\n\t\t\t\tns.nspname AS pronamespace\n\t\t\tFROM pg_catalog.pg_trigger t, pg_catalog.pg_proc p, pg_catalog.pg_namespace ns\n\t\t\tWHERE t.tgrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='{$table}'\n\t\t\t\tAND relnamespace=(SELECT oid FROM pg_catalog.pg_namespace WHERE nspname='{$c_schema}'))\n\t\t\t\tAND ( tgconstraint = 0 OR NOT EXISTS\n\t\t\t\t\t\t(SELECT 1 FROM pg_catalog.pg_depend d    JOIN pg_catalog.pg_constraint c\n\t\t\t\t\t\t\tON (d.refclassid = c.tableoid AND d.refobjid = c.oid)\n\t\t\t\t\t\tWHERE d.classid = t.tableoid AND d.objid = t.oid AND d.deptype = 'i' AND c.contype = 'f'))\n\t\t\t\tAND p.oid=t.tgfoid\n\t\t\t\tAND p.pronamespace = ns.oid";
        return $this->selectSet($sql);
    }
Postgres