Extract part of a string in Postgres
You can use the function substring() with a regular expression. But you need to define your requirements exactly. Like markp commented, there is ambiguity with multiple matches.

SELECT substring($string FROM '{conn-to,(.*?)},')


The part between parentheses is returned. This returns the first match, and the non-greedy quantifier *? prefers the shortest match.