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

[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