I want to create a common function used for every ...
# off-topic
h
I want to create a common function used for every table, is that possible?
@User I tried to create function and triggers like this:
Copy code
CREATE OR REPLACE FUNCTION public.update_updated_at()
RETURNS TRIGGER AS $$
BEGIN
  NEW.updated_at = TIMEZONE('utc' :: TEXT, NOW());
  RETURN NEW;
END;
$$ LANGUAGE plpgsql SECURITY DEFINER;

CREATE TRIGGER trigger_design_files_updated_at
BEFORE UPDATE ON public.design_files
FOR EACH ROW
EXECUTE PROCEDURE public.update_updated_at();
It works now! Failed because of forgetting to write
public
I guess. Thanks.