Postgres Data Modelling

[Michael Albers]

Hi,

Postgresql supports arrays, but I can't find a way to model this within EA.

Example:
I have a table named people. One of the columns is AdditionalGivenNames. Since I never know how many names someone has, I would like to store an array in this column. Each value would be varchar, so if I would create the table the syntax would be

Code: [Select]

CREATE people ( AdditionalGivenNames varchar[] );

Has anybody got any experience with this?

Thanks,
Michael