I think you can use OLD.field_name and NEW.field_name in triggers in Postgres. This is, however, for updates, not inserts. NEW.filed_name maybe there for inserts as well, but I don't remember for sure. Check the docs -- it is pretty well written section.