Display Data in a List format in PostgreSQL

Question

I have a table data like below :

Expected Result :

Query I am trying :

select Id, string_to_array(element_X::text,',')::int[] from table;

But its giving in a curly braces ( I understand, its just an array ). Is it possible to display it in a square bracket.

Result as of now :

Is it possible to display like that

Displaying results happens on the client. It should be easy to replace the braces of the text representation with brackets in client code. — Laurenz Albe
– Laurenz Albe, Commented Dec 23, 2020 at 5:28

Arun Palanisamy · Accepted Answer · 2020-12-23 05:46:46Z

1

Postgresql Documentation says

The decoration consists of curly braces ({ and }) around the array value plus delimiter characters between adjacent items

Its indeed the representation of array. If you want just for display you can use something like translate.

with arry as(
select id, string_to_array(element_X::text,',')::int[] as element_X_arry from table
)
select id, translate(element_X_arry::text,'{}','[]') from arry

Demo on db<>fiddle

edited Dec 23, 2020 at 5:46

answered Dec 23, 2020 at 5:40

Arun Palanisamy

5,4898 gold badges33 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Display Data in a List format in PostgreSQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest