TypeORM array is not supported in postgres?

javascript node.js postgresql typescript typeorm
ben berizovsky picture ben berizovsky · Aug 22, 2019 · Viewed 12.3k times · Source

I have a column kid_ages which is Integer[]. When migrating, I get the following error:

DataTypeNotSupportedError: Data type "Array" in "home.kid_ages" is not supported by "postgres" database.

I tried adding the following options to my column:

type: 'array'

and:

array: true,
default: [],
nullable: false,`

@Column({
  array: true,
  default: [],
  nullable: false,
})
kid_ages: string;`

Answer

thopaw picture thopaw · Aug 22, 2019

The docs says, that it should work:

@Column("int", { array: true })
array: number[];

this is from the example https://github.com/typeorm/typeorm/blob/master/test/functional/database-schema/column-types/postgres/entity/Post.ts

In your code the array property is no array. Have you tried kid_ages: string[];?

Related questions

What is this Javascript "require"?

I'm trying to get Javascript to read/write to a PostgreSQL database. I found this project on github. I was able to get the following sample code to run in node. var pg = require('pg'); //native libpq bindings = `var pg = …

Read More
What is the proper way to use the node.js postgresql module?

I am writing a node.js app on Heroku and using the pg module. I can't figure out the "right" way to get a client object for each request that I need to query the database. The documentation uses code …

Read More
Nodemon - "clean exit - waiting for changes before restart" during setup

I am trying to set up a RESTful API with Node and Postgres. I have run into a problem where whenever I attempt to run the server (using npm start) to test it locally, I get the following output: [nodemon] 1.14.10 […

Read More