Question

inserting a single string as array of string into postgresql text[]

  • 17 June 2022
  • 2 replies
  • 113 views

anyone know how do i convert a text value from a source and insert it as a single string in an array into a field in postgresql with type text[] ?

i have tried to format → utils → Text to line item 

but it did not work. it converts the text into array of charactors.

 

i tried using value with delimited [ valuehere ], but it gives the same result


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

hi,

this is the filter output

and the insert field

Userlevel 7
Badge +12

Hi @kevinoyen!

Could you share a screenshot of your Formatter step as that might help us to see if there’s something there that needs tweaking. Don’t forget to obscure any personal/private data from the screenshot. 

Could you also confirm the field type in postgreSQL ie what type of data is that field expecting? Thanks!