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
