CREATE TRIGGER update_mtime AFTER UPDATE ON customer FOR EACH ROW EXECUTE PROCEDURE CREATE OR REPLACE FUNCTION update_mtime RETURNS TRIGGER LANGUAGE plpgsql AS $$BEGIN NEW.mtime = now(); RETURN NEW; END;$$;;