Re: triggers
you mean it is possible to write it exactly like this:
CREATE TRIGGER before_trig
INSERT ON table1 REFERENCING NEW AS new
FOR EACH ROW
(
UNLOAD TO 'file' VALUES (new.col1, new.col2, new.col3, ...,
new.coln)system "cat file >> file.append"
);
?