insert JSONB in Postgresql

[julienChe]

Hello community,

On talend 8 ETL License with Java11, how to insert JSON in POSTGRESQL 16 in a JSONB column ? thanks

[quentin-vigne]

Hello @julienChe 

You need to start setting up the desired column in Talend to "string"

Then in your tDBOutput go to Advanced Settings

And in Additional Column add a new value with the same name as your output column :

in SQL Expression add : 

"?::json"

This help convert your string to json. We use "?" because it's a pattern matching character. 

In Position select Replace and in Reference column select the output column.

If we say that your json string is "abcdef" then Talend will output your data it will look like this : 

INSERT INTO table VALUES ("abcdef"::json)

- Quentin

[julienChe]

Hello @quentin-vigne ,

thank you very much for your reply, I'll test it as soon as possible and get back to you.
have a nice day!

[quentin-vigne]

If it works don't forget to accept it as a solution 

Have a good day

- Quentin