Automating timestamp fields in PostgreSQL
Different columns,


created_at this simple, just give it a DEFAULT now()
updated_at use the spi module which provides a higher-order trigger than can be applied to any table, see this post, also see row-modification-time
deleted_at how would you automated that anyway? What would that even look like? Just set it when you delete the post.