PostGIS Cookbook - Second Edition

There's more...

If we had multiple fields we wanted to normalize, we could write CREATE TABLE queries for each of them.

It is interesting to note that the approach framed in this recipe is not limited to cases where we have a delimited field. This approach can provide a relatively generic solution to the problem of normalizing flat files. For example, if we have a case where we have multiple fields to represent relational info, such as label1, label2, label3, or similar multiple attribute names for a single record, we can write a simple query to concatenate them together before feeding that info into our query.