I'm a Postgresql novice.
In a postgresql 9.2 + PostGIS instance I have one table with a
geometry(polygon, ssid) column. From this table I am trying to create a view using
ST_Centroid like so:
CREATE OR REPLACE VIEW schema.polys_points AS SELECT poly_table.name, ST_Centroid(geom) as geom FROM poly_table;
This produces a view with a
geometry() column where I would like it defined as
geometry(point, ssid) column. Is this possible?