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.
Add a comment
|
2 Answers
You can use the specificType method for that:
knex.schema.createTable('deal', function(t) {
t.increments()
t.specificType('deal', 'INT[]')
})
5 Comments
Sudhir Roy
Thanks. Also, How we define references for each deal? For ex: knex.integer('deal').references('user.id')
devius
You want to add a foreign key to a table?
Sudhir Roy
No, In integer array, I want to add foriegn key.
devius
Just chain
.references('user.id') to the specificType() call.
wmik
Incase anyone stumbles into this. It's not yet possible to define references for such a column. See this answer for more.
knex.schema.createTable('deal', function(t)
{
t.increments(),
t.specificType('deal', 'integer ARRAY')
})
One can like this aswell.
