Create PL/pgSQL function

sql

CREATE OR REPLACE FUNCTION set_updated_at()
RETURNS trigger AS $$
BEGIN
  NEW.updated_at = now();
  RETURN NEW;
END;
$$ LANGUAGE plpgsql;

Explanation

See summary for usage details.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Views, Functions, Triggers, and Extensions

Open an interactive psql session to a database.

Create a new database in the cluster.

Create a namespace for objects.

Insert one row into a table.

Fetch a sorted subset of rows.

Add a basic B-tree index to speed lookups.