Splitting a string into multiple strings using PostgreSQL

Question

I am receiving a string in an SQL query and will like to split it into multiple strings.

The string comes in with the format of:

('green, yellow, red')

I will like to change that to

('green', 'red', 'yellow')

Thanks!