Update timestamp when row is updated in PostgreSQL

by

Create a function that updates the changetimestamp column of a table like so:

CREATE OR REPLACE FUNCTION update_changetimestamp_column()
RETURNS TRIGGER AS $$
BEGIN
   NEW.changetimestamp = now(); 
   RETURN NEW;
END;
$$ language 'plpgsql';

Create a trigger on the table that calls the update_changetimestamp_column() function whenever an update occurs like so:

    CREATE TRIGGER update_ab_changetimestamp BEFORE UPDATE
    ON ab FOR EACH ROW EXECUTE PROCEDURE 
    update_changetimestamp_column();

More Related Contents:

  1. Generate series of dates – using date type as input
  2. Difference between timestamps with/without time zone in PostgreSQL
  3. now() default values are all showing same timestamp
  4. Importing .csv with timestamp column (dd.mm.yyyy hh.mm.ss) using psql \copy
  5. PostgreSQL: Show tables in PostgreSQL
  6. PostgreSQL “DESCRIBE TABLE”
  7. PostgreSQL function for last inserted ID
  8. What’s the fastest way to do a bulk insert into Postgres?
  9. Adding ‘serial’ to existing column in Postgres
  10. Making sense of Postgres row sizes
  11. How to persist data in a dockerized postgres database using volumes
  12. Time zone names with identical properties yield different result when applied to timestamp
  13. Permission denied for relation
  14. CONSTRAINT to check values from a remotely related table (via join etc.)
  15. How do I get a column with consecutive, increasing numbers, without having any numbers missing?
  16. Execute a dynamic crosstab query
  17. Copy a table from one database to another in Postgres
  18. User defined variables in PostgreSQL
  19. PostgreSQL query very slow with limit 1
  20. psql: FATAL: database “” does not exist
  21. Postgres FOR LOOP
  22. Storing Images in PostgreSQL
  23. pgAdmin III Why query results are shortened?
  24. How do I handle opening/closing Db connection in a Go app?
  25. clojure.java.jdbc lazy query
  26. PostgreSQL via SSH Tunnel
  27. How should I import data from CSV into a Postgres table using pgAdmin 3?
  28. PostgreSQL – set a default cell value according to another cell value
  29. Loop on tables with PL/pgSQL in Postgres 9.0+
  30. How to escape question mark (?) character with Spring JpaRepository

Leave a Comment