If there are any processing to be done with postgres array, it has to be dumped into json first, because native format representation is essentric.

SELECT name, array_to_json(alt spelling) FROM name_aliases;

postgresql json functions help page is an interesting read by itself

Sign in to participate in the conversation

Generalistic and moderated instance. All opinions are welcome, but hate speeches are prohibited. Users who don't respect rules will be silenced or suspended, depending on the violation severity.