How can we create integer array type column in knex migration?

Question

I have a table something like this:

Table: Deal Columns: Id int, deal int[]

Each entry in deal array references some other table id. How can we create the migration for the structure? Also, how can we create array column in knex for postgres.

score 19 · Accepted Answer · answered Feb 18 '18 at 19:35

19

You can use the specificType method for that:

knex.schema.createTable('deal', function(t) {
  t.increments()
  t.specificType('deal', 'INT[]')
})

answered Feb 18 '18 at 19:35

devius

2,736
22
26

Thanks. Also, How we define references for each deal? For ex: knex.integer('deal').references('user.id') – Sudhir Roy Feb 19 '18 at 22:59
You want to add a foreign key to a table? – devius Feb 20 '18 at 11:02
No, In integer array, I want to add foriegn key. – Sudhir Roy Feb 28 '18 at 21:27
1

Just chain `.references('user.id')` to the `specificType()` call. – devius Feb 28 '18 at 21:37
1

Incase anyone stumbles into this. It's not yet possible to define references for such a column. See [this answer](https://stackoverflow.com/a/41054753/8126654) for more. – wmik Jun 22 '19 at 10:37

score 1 · Answer 2 · answered Mar 07 '22 at 08:44

1

knex.schema.createTable('deal', function(t) 
{ 
    t.increments(),
    t.specificType('deal', 'integer ARRAY')
})

One can like this aswell.

answered Mar 07 '22 at 08:44

krishnazden

1,127
10
19

How can we create integer array type column in knex migration?

2 Answers2