sosedoff / pgweb

Cross-platform client for PostgreSQL databases
https://sosedoff.github.io/pgweb
MIT License
8.47k stars 716 forks source link

strange view of boolean array #735

Closed Quake4 closed 1 month ago

Quake4 commented 2 months ago

image

I would like to see it as in column 4.

And why doesn't array have square brackets '[]', but curly '{}'?

sosedoff commented 1 month ago

Im not sure what's the problem here. psql returns the same exact output:

Screenshot 2024-05-22 at 7 57 21 PM
Quake4 commented 1 month ago

Well, you completely output true and false as values. Why repeat controversial solutions in array? Even they have an define array with square brackets (array[true,false]), and the output is incomprehensible ;)

sosedoff commented 1 month ago

Formatting is not something Pgweb does, its dependency lib/pq is responsible for it.

Quake4 commented 1 month ago

see what you can do with bool values in arrays, at least replace t and f with true and false.

sosedoff commented 1 month ago

I don't have much interest in adding such a feature, its really not big of a deal to me. You're more than welcome to submit a patch to lib/pg, or pgweb projects if you really think its going to benefit larger audience.