Amina's Blog

Postgresql Array To String . Javascript by envious earthworm on jul 30 2020 comment. Usage string_to_array ( string text, delimiter text [, null_string text] ) → text[] note that string_to_array() is not suitable for general parsing of csv strings, as splits are made on each occurrence of the delimiter and it does not consider whether the delimiter is embedded within a quoted string. Valentine's tech log Getting arrays from PostgreSQL database using from tech.valgog.com Here is an example using regexp_split_to_table:. Cannot cast type jsonb to text[]. Let us create an employee table with the contact_number column as an array data.