I want to define a trigger in postgresql when updated a record in a db table, It output the record as a json file:
CREATE TABLE mytable(
id serial primary key,
first_name varchar(40) NOT NULL,
last_name varchar(40) NOT NULL
);
CREATE OR REPLACE FUNCTION myFunction() RETURNS trigger AS
$BODY$
BEGIN
// My Code
RETURN NEW;
END;
$BODY$
LANGUAGE plpgsql
SECURITY DEFINER;
CREATE TRIGGER myTrigger AFTER UPDATE ON mytable
FOR EACH ROW EXECUTE PROCEDURE myFunction();
How can I do it?