[mapserver-dev] Serving attributes from postgres hstore collumn as wfs.

[Paul Ramsey]

On Sun, Jan 29, 2012 at 10:48 AM, Morten Olsen Lysgaard
<morten at lysgaard.no> wrote:
> The hstore question can be summarized as follows:
>
> Has anyone used a hstore column in postgres for attributes on WFS features?

There's a mismatch between what hstore provides (schemaless key/value
storage) and what WFS provides (schema-tied attribute access). You
can't easily public schemaless data via WFS. As another response
points out, you can design a SQL query that maps keys in your hstore
into output attributes and then MapServer/WFS can happily publish
them, but in that case you might also have been better served by just
having those keys as columns in your table.

P.