Automating timestamp fields in PostgreSQL
2
votes
1
answer
2999
views
I'm trying to define the following table in PostgreSQL:
posts
- uuid
- title
- created_at
- updated_at
- deleted_at
The idea is that i never delete anything, so i change the deleted_at instead of removing the row and use
where deleted_at is null
for normal behavior.
Is there a way of automating those timestamps?
Asked by vinnylinux
(97 rep)
Jan 19, 2018, 02:59 AM
Last activity: Jan 19, 2018, 04:30 AM
Last activity: Jan 19, 2018, 04:30 AM