Concept: a trigger what creates a new record in a table after a new JSON object has been created in another table. I don't want to make any modifications yet, just to "convert" JSON objects to records with a trigger.
Add a comment
|
1 Answer
Use the function jsonb_populate_record() in the trigger function, e.g.
create or replace function json_input_trigger()
returns trigger language plpgsql as $$
begin
insert into main_table
select *
from jsonb_populate_record(null::main_table, new.data);
return new;
end $$;
3 Comments
Bence László
I really appreciate your example. Thank you. Can I improve my question in some way?
klin
I think your question is clear enough. But you can edit it if you want to add new aspects.
vhs
The example provided is perfect for experimentation. Thanks!