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.