Re: Array of foreign key - Mailing list pgsql-general

From Thomas Poty
Subject Re: Array of foreign key
Date
Msg-id CAN_ctniZMtuMPy++GNV_4w3FT+LWvXMWxSSzsq6Wm82MAT-n5g@mail.gmail.com
Whole thread Raw
In response to Re: Array of foreign key  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Responses Re: Array of foreign key
List 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 by date:

Previous
From: James Keener
Date:
Subject: Re: Does postgresq database supports reading data from the same table from many observable simultanousely?
Next
From: Melvin Davidson
Date:
Subject: Re: Array of foreign key