Postgresql multi value text field

Question

There is a filed in one of my DB tables that is a text field and contains multiple values (words). How do I go about returning only one of the words contained in the field. The field (state) looks like below, I would like to return the state name and state abbr separately to display is separate html table columns.

---
:name: California
:abbr: CA

Answer 1

After google-ing for a while I found and applied the split_part(string text, delimiter text, field int) function.

https://www.postgresql.org/docs/current/functions-string.html

split_part(colName, ':', 3)
split_part(colName, ':', 5)

This will return "California" and "CA" separately.