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

[Frank Gasdorf <fgdrf@xxxxxxxxxxxxxxxxxxxxx>]

Seems I missunderstood you...

You're trying to connect  to PostGIS DB which has a hstore extension installed? Then it would be much more a PostGIS Datastore question und GeoTools users-list with the hint that you are using hstore extension.

However, uDig 2.0.0.RC1 uses GeoTools 14.1 Release

HTH
--

Frank

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

Hi Frank

Many thanks for your response!

I use uDig 2.0.0.RC1 (64 bit version) on MacOSX 10.11.6 (El Capitan) and choose “Layer —> Add…”. On my installation there is no H2 - and only one PostGIS (with capital “GIS”) - so I choose PostGIS - connecting and everything works if I select a “non-hstore” table.

My list only includes:

ArcSDE

DB2

DataStore

Files

JGrass Workspace Wizard

Map Decoration

MySQL host

NASA WorldWind Configuration Files

Oracle Spatial

PostGIS <— which I selected

Web Feature Server

Web Map Server

Web Map Server Tile Cache (WMSC)

Web Map Tiles (OpenStreetMap, MapQuest Maps, ..)

kind regards

Michael

On 13.09.2016, at 10:57, Frank Gasdorf <fgdrf@xxxxxxxxxxxxxxxxxxxxx> wrote:

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

_______________________________________________
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