Database Reference
In-Depth Information
--------------+-------------------+-----------------+-------+-------
firenews | the_geom |
2 | 4326 | POINT
(1 row)
Tip
BeforePostGIS2.0,youhadtocreateatablecontainingspatialdatain
twodistinctsteps;infact,the
geometry_columns
viewwasatablethat
needed to be manually updated. For that purpose, you had to use the
AddGeometryColumn
function to create the column. For example, for
this recipe:
postgis_cookbook=> CREATE TABLE
chp01.firenews
(
x float8,
y float8,
place varchar(100),
size float8,
update date,
startdate date,
enddate date,
title varchar(255),
url varchar(255)
)
WITHOUT OIDS;
postgis_cookbook=> SELECT
AddGeometryColumn('chp01', 'firenews',
'the_geom', 4326, 'POINT', 2);
chp01.firenews.the_geom SRID:4326
TYPE:POINT DIMS:2
