ams
Reputation: 62652
How to create an autoupdating postgres timestamp column without using a trigger
On some of my tables I have some columns which contain a creation timestamp column that is supposed to be set on insert and a last update timestamp that is supposed to be updated on every update. I would like to do this without using a trigger is that possible?
Upvotes: 1
Views: 1304
Answers (1)
Adrian Serafin
Reputation: 7715
For creation time column you can set default yo NOW, but for last update time I think you will have to use trigger.
Btw. why you don't want triggers?
Upvotes: 2
Related Questions
- Creating a trigger that sets a timestamp on UPDATE
- Automatically populate a timestamp field in PostgreSQL when a new row is inserted
- Trigger function to update timestamp attribute when any value in the table is updated
- postgresql: How do i add a column which stores the time of creation of the row with timestamp automatically
- Create auto update trigger for single field update postgres
- Possible to automatically create a timestamp record on insert with Postgres?
- Update timestamp when row is updated in PostgreSQL
- postgresql - trigger, update timestamp on field update
- PostgreSQL how to set a Primary Key column with timestamp to automatically be filled
- Is there a way in PostgreSQL to automatically set the time a record was updated?