[OSM-dev] osm2pgsql: access flatfile from postgresql via foreign data wrapper

[Walter Nordmann]

Jochen123 wrote
> ...
> This is probably slightly easier to do than the postgresql fdw, but, of
> course, not as general.

It's no problem for me to do it with postgresql. I'v done that before whilst
working with the osmosis/snapshot-schema. i could "dump" osm-objects (nodes,
ways and relations) directly from my database using some simple
pl/pgsql-functions.

something like /select wno_asosm('R',1111111);/ dumped the relation with all
ways and all nodes to an osm-file. Even relations as members. But now i'm
missing the nodes :(

First step: try to read the flatfile with /persistent_cache_nodes_get/ from
osm2pgsql and fetch some nodes.
next: convert flatfile to csv and use postgresql /file_fdw/ as a  simple
data wrapper
last step: write own wrapper? may be i don't have to.

regards
walter





-----
[url=http://osm.wno-edv-service.de/residentials] Missing Residentials Map 1.17[/url] [url=http://osm.wno-edv-service.de/plz] Postcode Map 2.0.2[/url]
--
View this message in context: http://gis.19327.n5.nabble.com/osm2pgsql-access-flatfile-from-postgresql-via-foreign-data-wrapper-tp5784817p5784824.html
Sent from the Developer Discussion mailing list archive at Nabble.com.