Re: Array of foreign key

Поиск
Список
Период
Сортировка
От Thomas Poty
Тема Re: Array of foreign key
Дата
Msg-id CAN_ctniZMtuMPy++GNV_4w3FT+LWvXMWxSSzsq6Wm82MAT-n5g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Array of foreign key  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Ответы Re: Array of foreign key  (Melvin Davidson <melvin6925@gmail.com>)
Список pgsql-general
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. 

Thank you Andreas. 

Thomas


Le 22 déc. 2017 20:22, "Andreas Kretschmer" <andreas@a-kretschmer.de> a écrit :
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?


Regards, Andreas


--
2ndQuadrant - The PostgreSQL Support Company

В списке pgsql-general по дате отправления:

Предыдущее
От: James Keener
Дата:
Сообщение: Re: Does postgresq database supports reading data from the same table from many observable simultanousely?
Следующее
От: Melvin Davidson
Дата:
Сообщение: Re: Array of foreign key