Re: [udig-users] HSTORE or VIEW support for PostGIS?

[Frank Gasdorf <fgdrf@xxxxxxxxxxxxxxxxxxxxx>]

Michael,

I assume you are using the Add data wizard and the data Store option on the first page. Which entry do you select on the next page (http://udig.github.io/docs/user/reference/DataStore%20page.html)?

If you select H2 we should claryfiy which version of uDig you are working with because the datastore implementation is done by GeoTools project.
After we found out uDig we can identify GeoTools version thats included ...

which you need to ask your questions on GeoTools users-list

HTH
---

Frank

2016-09-13 10:42 GMT+02:00 Michael Kussmaul <kussmaul.list@xxxxxx>:

Hi

I like uDig and use it together with OpenStreetMap data stored in a PostGIS database. As you know OpenStreetMap has many many feature classes so instead of having fixed columns (name, …) I use the hstore extension for all attributes.

Now my problem, is there a way to use hstore columns in uDig? When I tried to connect, I uDig only shows non-hstore columns. And because I like to filter results is it possible to add a hstore query?

Because I have not yet found a way to extract data using hstore in uDig - I then tried to work around the problem by adding a custom view (which maps the filtered hstore entries into a “normal” view), but I can’t seem to access any views in uDig.

Is this somehow possible to achieve?

kind regards
Michael
_______________________________________________
udig-users mailing list
udig-users@xxxxxxxxxxxxxxxx
To change your delivery options, retrieve your password, or unsubscribe from this list, visit
https://www.locationtech.org/mailman/listinfo/udig-users