Run plpgsql function after 7 days from trigger.
So I had an idea for handling banned users. When I update
is_banned row from user's profile from profiles table It would hide his posts that are connected by his uuid with images table. Now I want to make something like deletion his profile and posts from database after 7 days. Is it even possible? I know maybe database triggers with functions may do a trick but I'm not sure. Any ideas?