Nahrnuto

Prevzato z http://postgres.cz/wiki/PostGIS_pro_v%C3%BDvoj%C3%A1%C5%99e Tabulky spatial_ref_sys a geometry_columns.

01 ------------------------------------------------------------------- 02 -- SPATIAL_REF_SYS 03 ------------------------------------------------------------------- 04 CREATE TABLE spatial_ref_sys ( 05 srid integer not null primary key, 06 auth_name varchar(256), 07 auth_srid integer, 08 srtext varchar(2048), 09 proj4text varchar(2048) 10 ); 11 12 ------------------------------------------------------------------- 13 -- GEOMETRY_COLUMNS 14 ------------------------------------------------------------------- 15 CREATE TABLE geometry_columns ( 16 f_table_catalog varchar(256) not null, 17 f_table_schema varchar(256) not null, 18 f_table_name varchar(256) not null, 19 f_geometry_column varchar(256) not null, 20 coord_dimension integer not null, 21 srid integer not null, 22 type varchar(30) not null, 23 CONSTRAINT geometry_columns_pk primary key ( 24 f_table_catalog, 25 f_table_schema, 26 f_table_name, 27 f_geometry_column ) 28 ) WITH OIDS;