Follow

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 postgresql.org/docs/9.3/functi

Sign in to participate in the conversation
Mastodon

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.