On Mon, 2023-11-06 at 21:15 -0700, Sbob wrote:
> does anyone know: can I create a trigger on a foreign table? I suspect I
> have to create the trigger on the remote / source table yes?
You can create a trigger on a foreign table. But don't get confused:
- the trigger will run locally, not on the remote database
- the trigger will not run if the table on the remote database is modified
Yours,
Laurenz Albe