Dear community
I'm struggling with inserting files into a Postgres DB. It is the whole
content of a file which has to be inserted into one field in one record.
Not each line/record in the field.
The PutSQL process expect the content of an incoming FlowFile to be the SQL
command to execute. Not data to add to the database.
I managed to use a ReplaceText Process to alter the content to include the:
INSERT INTO tablename (content)
VALUES ('$1')
where $1 is equal to the whole content. But the content has special
characters and is failing.
Please any advice how to insert all content of a file into one record/field?
kind regards
Jens
