split a string using psql query
using the function split_part() in postgresql, we can split a string with delimiter from the table field values
Syntax: split_part(string,delimiter,return field)
Example: SELECT * FROM table_name WHERE split_part(table_field,delimiter,return field) = “value”;
