In version 24.2 DbVisualizer introduced a new presentation for arrays in the result tab.
In older versions the query SELECT array_agg(x.elem) FROM (VALUES ('abc'), ('def')) x (elem); would have resulted in {abc,def}. Now it is ["abc","def"].
Is there any way, to change the output to the old format?
I’d expected to find a new option in the “Data Format” section of the settings – but there is none.
New contributor
Thervanda is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.