Array of types in migrations

[tavaresgerson]

Hello guys!

Its possible create an array of types, for example: string[], integer[] for use in Postgres database.

Thanks for your help!

[tavaresgerson]

So, it's possible with table.specificType.

For example, an array of type double:

table.specificType('first_coord', 'double precision[]')

hope this helps someone 🎧

[florian-lefebvre]

I had to add the following properties to the column decorator:

  @column({ 
     prepare: (value: string[]): string => `{${value.join(',')}}`,
     consume: (value: string): string[] => value.slice(1, -1).split(','), 
   })

[tavaresgerson]

Yeah, this is an alternative. Thanks bro