Hi Walter Just a small hint: There exists two FDW which could be of interest here: The file_fdw [1] (which is part of the Additional Supplied Modules) and file_fixed_length_record_fdw . I assume your're interested more in the file_fixed_length_record_fdw since OSM nodes are of fixed length. Be aware that AFAIK there is no precompiled binary distribution of that.
Yours, Stefan [1] http://wiki.postgresql.org/wiki/Foreign_data_wrappers#file_fdw [2] http://wiki.postgresql.org/wiki/Foreign_data_wrappers#file_fixed_length_record_fdw [3] https://github.com/adunstan/file_fixed_length_record_fdw 2013/11/10 Walter Nordmann <pil...@hotmail.com> > 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. > > _______________________________________________ > dev mailing list > dev@openstreetmap.org > https://lists.openstreetmap.org/listinfo/dev >
_______________________________________________ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev
