[ https://issues.jboss.org/browse/TEIID-3301?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3301: --------------------------------------- Yes that should be fine. > Add GEOMETRY_COLUMNS view > ------------------------- > > Key: TEIID-3301 > URL: https://issues.jboss.org/browse/TEIID-3301 > Project: Teiid > Issue Type: Feature Request > Reporter: Tom Arnold > Assignee: Steven Hawkins > Labels: spatial > > Another OGC Simple Features implementation detail. Basically this is like a specialized version of SYS.COLUMNS, and would be used to support GIS software (like GeoServer). > http://www.carocoops.org/resources/doc/postgis/x321.html > {code} > CREATE TABLE GEOMETRY_COLUMNS ( > F_TABLE_CATALOG VARCHAR(256) NOT NULL, > F_TABLE_SCHEMA VARCHAR(256) NOT NULL, > F_TABLE_NAME VARCHAR(256) NOT NULL, > F_GEOMETRY_COLUMN VARCHAR(256) NOT NULL, > COORD_DIMENSION INTEGER NOT NULL, > SRID INTEGER NOT NULL, > TYPE VARCHAR(30) NOT NULL > ) > {code} -- This message was sent by Atlassian JIRA (v6.3.11#6341)