easiest way to manage both "created" and "updated" timestamps on a record in postgesql

create function manage_magic_timestamp_c.sql

-- in schema as procedure:

create function manage_magic_timestamp_columns() returns trigger
    strict
    cost 1
    language plpgsql
as
$$
BEGIN
    -- is a new record?
    IF TG_OP = 'INSERT' THEN
       -- yes, set created at
        NEW.created_at = current_timestamp;
    END IF;
    -- bump updated at column
    NEW.updated_at = current_timestamp;
    -- all done
    RETURN NEW;	
END;
$$;

comment on function manage_magic_timestamp_columns() is 'Manage magic timestamp columns';

alter function manage_magic_timestamp_columns() owner to --your username here--;



-- on table:

-- Trigger: table_magic_ts_tr
-- DROP TRIGGER table_magic_ts_tr ON public.table;

CREATE TRIGGER table_magic_ts_tr
    BEFORE INSERT OR UPDATE 
    ON public.table
    FOR EACH ROW
    EXECUTE PROCEDURE public.manage_magic_timestamp_columns();