Automatic completion of fields?

Question

PostgreSQL

Hello. How to correctly implement that when a record is inserted into the table, the created_at, updated_at fields are automatically updated. And when updating records, only updated_at. Thank you.

Answer 1

https://www.postgresql.org/docs/current/static/ddl...
When updating either by a trigger or in the update query itself.

Answer 2

Hang a trigger , inside there will be something like:BEFORE INSERT OR UPDATE

NEW.updated_at = now();
IF TG_OP = 'INSERT' THEN
  NEW.created_at = now();
END IF;