topic Re: insert JSONB in Postgresql in Talend Studio

insert JSONB in Postgresql

julienChe — Thu, 20 Feb 2025 09:51:31 GMT

Hello community,

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

quentin-vigne — Wed, 05 Mar 2025 08:57:38 GMT

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 — Tue, 25 Mar 2025 09:34:19 GMT

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 — Tue, 25 Mar 2025 10:04:05 GMT

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

Have a good day

- Quentin