I have defined a materialized view in a PostGIS 2.1-enabled database running PostgreSQL 9.3.1:
CREATE MATERIALIZED VIEW canvec_data.contours_m AS
SELECT
contours_original.ogc_fid,
contours_original.elevation::integer AS elevation_orig,
CASE
WHEN "substring"(contours_original.code::text, 1, 3) = '257'::text THEN round(contours_original.elevation::double precision * 0.3048::double precision)
ELSE contours_original.elevation::double precision
END AS elevation_m,
contours_original.wkb_geometry::geometry(Linestring,3578)
FROM canvec_data.contours_original
I had, perhaps erroneously, expected that this resultant entity (a table?) would be listed in the public.geometry_columns
view, and thus be properly interpreted by GIS viewer software such as QGIS.
The materialized view does not appear in the public.geometry_columns
view.
What am I doing wrong?
Thanks!