Actually, We are migrating from Mysql to postgresql and we have to replace sets of Mysql. The migration we will be done in 2 steps: First, in a like for like way. Second step will be using postgresql powerfulness
I think the most like for like way to migrate sets is using enum array.
On 22 December 2017 20:02:43 CET, Thomas Poty <thomas.poty@gmail.com> wrote: >Hello all, > >I use postgresql 9.5 and I am looking for way to have a column which is >an >array of a foreign key. If what I read is correct it is currently not >possible... Have you any idea how to implement this feature in a safe >way
Normalisation?
Can you explain that a bit more, what's the use-case?