| public getTrigger ( $table, $trigger ) : A | ||
| $table | The name of a table whose triggers to retrieve | |
| $trigger | The name of the trigger to retrieve | |
| return | A | recordset |
function getTrigger($table, $trigger)
{
$c_schema = $this->_schema;
$this->clean($c_schema);
$this->clean($table);
$this->clean($trigger);
$sql = "\n\t\t\tSELECT * FROM pg_catalog.pg_trigger t, pg_catalog.pg_class c\n\t\t\tWHERE t.tgrelid=c.oid AND c.relname='{$table}' AND t.tgname='{$trigger}'\n\t\t\t\tAND c.relnamespace=(\n\t\t\t\t\tSELECT oid FROM pg_catalog.pg_namespace\n\t\t\t\t\tWHERE nspname='{$c_schema}')";
return $this->selectSet($sql);
}