Question

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

  • 17 June 2022
  • 2 replies
  • 107 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

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!

hi,

this is the filter output

and the insert field