Notify using postgresql intervals

Question

Say, like I have a table videoplan:

create table video_plan(
id integer,
startdate timestamp,
enddate timestamp)

So I'm having startdate: 01.02.2022, enddate: 28.02.2022

Here, I need to show a notification like 'Renew Plan' 1 week before the enddate. How to get that in PostgreSQL?

Answer 1

The database won't notify you. You have to query regularly with something like

SELECT ...
FROM video_plan
WHERE enddate < current_timestamp + INTERVAL '1 week';