How do I automatically update a timestamp in PostgreSQL

by

To populate the column during insert, use a DEFAULT value:

CREATE TABLE users (
  id serial not null,
  firstname varchar(100),
  middlename varchar(100),
  lastname varchar(100),
  email varchar(200),
  timestamp timestamp default current_timestamp
)

Note that the value for that column can explicitly be overwritten by supplying a value in the INSERT statement. If you want to prevent that you do need a trigger.

You also need a trigger if you need to update that column whenever the row is updated (as mentioned by E.J. Brennan)

Note that using reserved words for column names is usually not a good idea. You should find a different name than timestamp

More Related Contents:

  1. How do IMMUTABLE, STABLE and VOLATILE keywords effect behaviour of function?
  2. Keep PostgreSQL from sometimes choosing a bad query plan
  3. Copying PostgreSQL database to another server
  4. Primary keys with Apache Spark
  5. How can I put a database under git (version control)?
  6. Store query result in a variable using in PL/pgSQL
  7. Can I rollback a transaction I’ve already committed? (data loss)
  8. Kill a postgresql session/connection
  9. PostgreSQL: Drop PostgreSQL database through command line [closed]
  10. Do stored procedures run in database transaction in Postgres?
  11. Import SQL dump into PostgreSQL database
  12. how to use Blob datatype in Postgres
  13. How can I solve Postgresql SCRAM authentication problem?
  14. Convert SQLITE SQL dump file to POSTGRESQL
  15. Is it better to use multiple databases with one schema each, or one database with multiple schemas? [closed]
  16. How to login and authenticate to Postgresql after a fresh install?
  17. PostgreSQL Database Log Transaction
  18. Connect to a heroku database with pgadmin
  19. Starting and populating a Postgres container in Docker
  20. Adding a new value to an existing ENUM Type
  21. How can I import a .sql file into my Heroku postgres database?
  22. Backup/Restore a dockerized PostgreSQL database
  23. Should each and every table have a primary key?
  24. When and why are database joins expensive?
  25. How SID is different from Service name in Oracle tnsnames.ora
  26. Query that ignore the spaces
  27. XML data to PostgreSQL database [closed]
  28. Best representation of an ordered list in a database?
  29. Creating test data in a database [closed]
  30. Mysql service won’t start, InnoDB init function error

Leave a Comment