How to create an event trigger in Postgres? When a user finished loading a new table on to it, the trigger can start off an script 10 minutes after the event?
You could have a script execute every minute (say via cron)
Vendor-specific, but on AWS, you can invoke a lambda from RDS or Aurora.
1. An event trigger function runs after CREATE TABLE and invokes a lambda.
4. In the second step, have the lambda perform whatever operation(s) you need to do.
No polling required, but you'd have to be running in a managed service in the Amazon Cloud.
Similarly, if you are self-hosting and willing/able to write some C code or run some pl/pythonu, you could create an extension/function that performs this logic.
Or again if you are self-managed and go the cron route as suggested by David Johnson, there's the extension pg_cron.
