Version 4 (modified by cedric, 15 years ago) (diff) |
---|
-- Table: ccm21.seaoutlets drop view v_selected; create view v_selected as( select gid,wso_id,the_geom from ccm21.seaoutlets where system_cd not in ('C','N','I','H','V') except (select gid,wso_id,the_geom from ccm21.seaoutlets where system_cd = 'M' and sea_cd =5)); INSERT INTO geometry_columns(f_table_catalog, f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, "type") SELECT '', 'public', 'v_selected', 'the_geom', ST_CoordDim(the_geom), ST_SRID(the_geom), GeometryType(the_geom) FROM v_selected LIMIT 1;
Il seems that one basin is lacking in Turkey, not really a pb