I am trying to use a postgreSQL data base column to store values from an array (or point to an enum table which does this). I will get an array of data like ['one','two','five']
. The array can contain any amount of items from 0 to 10.
I have an enum table with these values:
id value
1 one
2 two
3 three
4 four
5 five
I want my database cell to point to all of the values that are contained in the array. Is this even possible or is there a common way to structure database tables to fix this issue.
So my desired solution when passed the array ['one','two','five']
would be to have a single cell in my database hold the enum pointers 1, 2, 5
.