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

Paul Ramsey pramsey at opengeo.org
Mon Jan 30 14:22:28 EST 2012


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.


More information about the mapserver-dev mailing list