Skip to main content
Database Administrators

Return to Answer

added 63 characters in body
Source Link
Sascha Mayr
Sascha Mayr
  • 23
  • 7

There is a specific syntax for this in PostgreSQL, see documentation:

CREATE TRIGGER trigger_name
AFTER UPDATE OF column_namecolumn_name1, column_name2, column_name3, column_name4, ..., column_name24 ON table_name
FOR EACH ROW
EXECUTE FUNCTION function_name;

By using OF column_name the trigger will only be called if that specific column changes.

There is a specific syntax for this in PostgreSQL, see documentation:

CREATE TRIGGER trigger_name
AFTER UPDATE OF column_name ON table_name
FOR EACH ROW
EXECUTE FUNCTION function_name;

By using OF column_name the trigger will only be called if that specific column changes.

There is a specific syntax for this in PostgreSQL, see documentation:

CREATE TRIGGER trigger_name
AFTER UPDATE OF column_name1, column_name2, column_name3, column_name4, ..., column_name24 ON table_name
FOR EACH ROW
EXECUTE FUNCTION function_name;

By using OF column_name the trigger will only be called if that specific column changes.

improved formatting
Source Link
tinlyx
tinlyx
  • 3.7k
  • 14
  • 48
  • 79

There is a specific syntax for this in PostgreSQL, see documentation:

CREATE TRIGGER trigger_name
AFTER UPDATE OF column_name ON table_name
FOR EACH ROW
EXECUTE FUNCTION function_name;

By using OF column_nameOF column_name the trigger will only be called if that specific column changes.

There is a specific syntax for this in PostgreSQL, see documentation

CREATE TRIGGER trigger_name
AFTER UPDATE OF column_name ON table_name
FOR EACH ROW
EXECUTE FUNCTION function_name;

By using OF column_name the trigger will only be called if that specific column changes.

There is a specific syntax for this in PostgreSQL, see documentation:

CREATE TRIGGER trigger_name
AFTER UPDATE OF column_name ON table_name
FOR EACH ROW
EXECUTE FUNCTION function_name;

By using OF column_name the trigger will only be called if that specific column changes.

Source Link
Sascha Mayr
Sascha Mayr
  • 23
  • 7

There is a specific syntax for this in PostgreSQL, see documentation

CREATE TRIGGER trigger_name
AFTER UPDATE OF column_name ON table_name
FOR EACH ROW
EXECUTE FUNCTION function_name;

By using OF column_name the trigger will only be called if that specific column changes.