Postgresql trigger for when timestamp is reached

Question

I'm building a table that stores user subscription details in Postgresql. Is there some sort of trigger function or event for when certain timestamp is reached? Example: User: A, Subscribed at: 17:00:00 11/01/2019, Expires in: 1 month Do postgresql supports something like setTimeout(1 month) or setInterval(1 month)?

I've read the postgres documentation on trigger which says that functions can be triggered only on operation (crud).

No, there’s nothing like that built in. You’ll have to handle those things separately. pgAgent may be useful — Sami Kuhmonen
– Sami Kuhmonen, Commented May 11, 2019 at 9:02

A. Scherbaum · Accepted Answer · 2019-05-11 20:14:49Z

1

There is pg_cron which can handle this kind of tasks.

answered May 11, 2019 at 20:14

A. Scherbaum

8555 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgresql trigger for when timestamp is reached

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related