Store array of string in typeorm postgres database

Viewed 5421

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?

2 Answers

I was able to resolve this with

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

This should work for an array.

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