[Tile-serving] [openstreetmap/osm2pgsql] Add an sql wrapper around passed value in an add_row function (#1524)

Nikolai Lebedev notifications at github.com
Tue Jun 8 14:13:12 UTC 2021


Last addition to a flex backend adds an sql_type, which is quite handy.
Another great feature could be addition of sql wrapper around passed column value in add_row function.
I guess all column values are being passed to a generated sql COPY command. 
This process is unreachable for lua script. Can it be exposed?
For example something like this

```lua
function osm2pgsql.process_node(object)
    tables.mytable:add_row({
        tags = 'jsonb_strip_nulls(' .. object.tags .. ')',
        geom = { create = "point" }
    })
end
```

Concatenation is used just to give an idea, real implementation could of course be cleaner.



-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/discussions/1524
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20210608/c04e039f/attachment.htm>


More information about the Tile-serving mailing list