In PostgreSQL 10.10, I have created a trigger function that converts the `
NEW` row to a JSON object using
`to_jsonb(NEW)`. But now I need to include the records on the other side of the foreign keys in
`NEW` record in the JSON object in a nested fashion.
What is the best and most generic way to accomplish this without prior knowledge about the schema of the `
NEW` record? I need to keep this trigger function as generic as possible, because I plan to use it on all tables. One level of depth in
following foreign keys is currently enough for me.