PostgreSQL has this feature to add text comments to tables and columns.
- https://www.postgresql.org/docs/current/sql-comment.html
This can be useful to share documentation on the data.
Some tile servers like Martin use this information when they generate their
TileJSON.
- https://www.postgresql.org/docs/current/sql-comment.html
It would be nice if I could specify those comments right in my osm2pgsql
`define_table` section.
Maybe likeā¦
```lua
local db_table = osm2pgsql.define_table({
name = 'foo_name',
description = 'foo data for some purpose',
ids = { type = 'any', id_column = 'osm_id', type_column = 'osm_type' },
columns = {
{ column = 'id', type = 'text', not_null = true },
{ column = 'tags', type = 'jsonb' },
{ column = 'geom', type = 'point' },
{ column = 'minzoom', type = 'integer', description = 'Used by tile
rendering functions to filter data based on zoom' },
}
})
```
--
Reply to this email directly or view it on GitHub:
https://github.com/osm2pgsql-dev/osm2pgsql/discussions/2331
You are receiving this because you are subscribed to this thread.
Message ID: <osm2pgsql-dev/osm2pgsql/repo-discussions/[email protected]>_______________________________________________
Tile-serving mailing list
[email protected]
https://lists.openstreetmap.org/listinfo/tile-serving