[Tile-serving] [osm2pgsql-dev/osm2pgsql] How to get node id list into column (Discussion #2216)

[Jochen Topf]

Quoting [this chapter](https://osm2pgsql.org/doc/manual.html#defining-columns) in the documentation: *For special cases you usually want to keep the type field unset and only set the sql_type field. So if you want to have an array of integer column, for instance, set only the sql_type to int[]. The type field will default to text which means you have to create the text representation of your array in the form that PostgreSQL expects it.*

See the [PostgreSQL docs](https://www.postgresql.org/docs/current/arrays.html) for that.

-- 
Reply to this email directly or view it on GitHub:
https://github.com/osm2pgsql-dev/osm2pgsql/discussions/2216#discussioncomment-10172071
You are receiving this because you are subscribed to this thread.

Message ID: <osm2pgsql-dev/osm2pgsql/repo-discussions/2216/comments/10172071 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20240728/1d08b13b/attachment.htm>