How convert PostgreSQL Array to JS

Question

How to convert PostgreSQL Array in string eg. "{1,2,3,4}" to javascript/typescript array: [1,2,3,4]. The values in the array must be a number type.

I tried a solution with replace and split but it returns string values.

var test = "{1,2,3,4}";
test = test.replace("{", "");
test = test.replace("}", "");
//test = test.replace(/\{|\}/gm, "")  //regex replace
test.split(",")   //['1', '2', '3', '4']

You should not have to do this. The postgresql driver should do it for you. Which one are you using ? — Denys Séguret
– Denys Séguret, Commented Jan 3, 2019 at 11:30
u can replace curly brackets with square then use JSON.parse method. like this JSON.parse(test.replace("{", "[").replace("}", "]")) — shajji
– shajji, Commented Jan 3, 2019 at 11:35
@DenysSéguret I do not have access to what the entire backend does. — ambussh
– ambussh, Commented Jan 3, 2019 at 11:36
Fixing the backend would probably be the right solution but I know not all projects are ideally managed... — Denys Séguret
– Denys Séguret, Commented Jan 3, 2019 at 11:38
PostgreSQL supports JSON type I recommend you use that, it's more efficient and there's no reason to incorrectly format an array in it — nanobar
– nanobar, Commented Jan 3, 2019 at 11:43

Denys Séguret · Accepted Answer · 2019-01-03 11:35:26Z

4

A cleaner solution not involving building a JSON string just to parse it:

test = test.match(/[\w.-]+/g).map(Number)

But when dealing with a database you're usually not supposed to parse the data yourself unless you're writing the driver (but there are already good ones for postgresql).

edited Jan 3, 2019 at 11:35

answered Jan 3, 2019 at 11:29

Denys Séguret

384k90 gold badges813 silver badges779 bronze badges

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

Comments

ambussh · Accepted Answer · 2019-01-03 11:24:53Z

1

I find solution with JSON.parse but this also need replace before conversion.

var test = "{1,2,3,4}";
test = test.replace("{", "[");
test = test.replace("}", "]");
JSON.parse(test)  //[1, 2, 3, 4]

Test with building a string for array size: 100000~900000: https://stackblitz.com/edit/typescript-gavnpg

answered Jan 3, 2019 at 11:24

ambussh

7901 gold badge8 silver badges18 bronze badges

Comments

John Guirguis · Accepted Answer · 2019-04-23 16:38:47Z

1

JSON.parse("[" + test.slice(1, test.length-1) + "]")

answered Apr 23, 2019 at 16:38

John Guirguis

134 bronze badges

1 Comment

d_kennetz Over a year ago

Please add context to your answer explaining how this is a solution to the problem. Thanks! --From Review

Collectives™ on Stack Overflow

How convert PostgreSQL Array to JS

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related