Store array of string in typeorm postgres database

Question

I would like to store an array of strings in my Postgres database, I have the below code but it is not working as I want:

  @Column({type: 'text', array: true, nullable: true })
  names: string[] = [];

I got the following error:

PostgreSQL said: malformed array literal: "["james"]"
Detail: "[" must introduce explicitly-specified array dimensions.

Anything I might be doing wrong?

Oleg Abrazhaev · Accepted Answer · 2023-12-11 09:46:23Z

14

I was able to resolve this with

  @Column('simple-array', { nullable: true, array: true })
  city: string[];

edited Dec 11, 2023 at 9:46

Oleg Abrazhaev

2,8792 gold badges33 silver badges41 bronze badges

answered Oct 11, 2020 at 6:11

dealwap

7313 gold badges17 silver badges38 bronze badges

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

1 Comment

Konrad Gałęzowski Over a year ago

In my case TypeORM saved string as "{"a", "b", "c"}" and could not parse it properly when fetched from DB. What helped was adding array: true to column definition: @Column({type: "simple-array", array: true})

Onesmus Muna · Accepted Answer · 2022-09-14 18:03:43Z

3

This should work for an array.

@Column('text', { array: true })
names: string[];

answered Sep 14, 2022 at 18:03

Onesmus Muna

4614 silver badges5 bronze badges

Collectives™ on Stack Overflow

Store array of string in typeorm postgres database

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related