What is String_To_Array function in PostgreSQL?

Answer:

This functions splits a string to an array provided the delimeter is supplied. It returns an array.

Syntax: String_To_Array(String,delimeter)

e.g.

Select String_To_Array('Hello World Today I am learning String_To_Array It is very cool',' ')

/* Result */
string_to_array
----------------
{Hello,World,Today,I,am,learning,String_To_Array,It,is,very,cool}