I'm using a postgres database created by a script (Osm2pgsql). It has created some fields with the type
_text for two dimensional arrays of
text. I'm trying to understand why it didn't just create a
text field, and why this type exists in postgres.
I can find this link in the docs which says:
When you define a new base type, PostgreSQL automatically provides support for arrays of that type. The array type typically has the same name as the base type with the underscore character (_) prepended.
But I don't understand why it is using this "underscored" type name when text is a built in type of postgres?