Postgres auto-updating timestamps

README.md

Auto-updating timestamps in Postgres

A Postgres function to change the updated_at column of a record on INSERT/UPDATE

set_updated_at.sql

-- The set_updated_at() function
CREATE FUNCTION set_updated_at() 
RETURNS TRIGGER AS $$
BEGIN
    NEW.updated_at = now();
    RETURN NEW; 
END;
$$ language 'plpgsql';

-- Assigning the function as a TRIGGER on a table (e.g. mytable)
CREATE TRIGGER set_mytable_updated_at BEFORE UPDATE ON mytable FOR EACH ROW EXECUTE PROCEDURE set_updated_at()