Difference between revisions of "Nahrnuto"
From Wikivyuka
m |
m |
||
| Line 2: | Line 2: | ||
Tabulky spatial_ref_sys a geometry_columns. | Tabulky spatial_ref_sys a geometry_columns. | ||
| − | 01 ------------------------------------------------------------------- | + | 01 ------------------------------------------------------------------- |
| − | 02 -- SPATIAL_REF_SYS | + | 02 -- SPATIAL_REF_SYS |
| − | 03 ------------------------------------------------------------------- | + | 03 ------------------------------------------------------------------- |
| − | 04 CREATE TABLE spatial_ref_sys ( | + | 04 CREATE TABLE spatial_ref_sys ( |
| − | 05 srid integer not null primary key, | + | 05 srid integer not null primary key, |
| − | 06 auth_name varchar(256), | + | 06 auth_name varchar(256), |
| − | 07 auth_srid integer, | + | 07 auth_srid integer, |
| − | 08 srtext varchar(2048), | + | 08 srtext varchar(2048), |
| − | 09 proj4text varchar(2048) | + | 09 proj4text varchar(2048) |
| − | 10 ); | + | 10 ); |
| − | 11 | + | 11 |
| − | 12 ------------------------------------------------------------------- | + | 12 ------------------------------------------------------------------- |
| − | 13 -- GEOMETRY_COLUMNS | + | 13 -- GEOMETRY_COLUMNS |
| − | 14 ------------------------------------------------------------------- | + | 14 ------------------------------------------------------------------- |
| − | 15 CREATE TABLE geometry_columns ( | + | 15 CREATE TABLE geometry_columns ( |
| − | 16 f_table_catalog varchar(256) not null, | + | 16 f_table_catalog varchar(256) not null, |
| − | 17 f_table_schema varchar(256) not null, | + | 17 f_table_schema varchar(256) not null, |
| − | 18 f_table_name varchar(256) not null, | + | 18 f_table_name varchar(256) not null, |
| − | 19 f_geometry_column varchar(256) not null, | + | 19 f_geometry_column varchar(256) not null, |
| − | 20 coord_dimension integer not null, | + | 20 coord_dimension integer not null, |
| − | 21 srid integer not null, | + | 21 srid integer not null, |
| − | 22 type varchar(30) not null, | + | 22 type varchar(30) not null, |
| − | 23 CONSTRAINT geometry_columns_pk primary key ( | + | 23 CONSTRAINT geometry_columns_pk primary key ( |
| − | 24 f_table_catalog, | + | 24 f_table_catalog, |
| − | 25 f_table_schema, | + | 25 f_table_schema, |
| − | 26 f_table_name, | + | 26 f_table_name, |
| − | 27 f_geometry_column ) | + | 27 f_geometry_column ) |
| − | 28 ) WITH OIDS; | + | 28 ) WITH OIDS; |
Revision as of 07:44, 5 February 2015
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;
