Hi,
for adding a geometry-column to an existing table use one of the
postgis-functions "select AddGeometryColumn(...);" described in:
http://postgis.refractions.net/documentation/manual-1.5/AddGeometryColumn.html
Ludwig
Am 17.01.2011 18:35, schrieb "Plata Martínez, Álvaro (KNMI)":
Hi,
Using postgreSQL 8.4 and Postgis 1.4 in an Ubuntu 10.04 Server, when
trying to create a table:
CREATE TABLE observation (
(...)
spatial_value geometry,
);
I get this error message:
ERROR: type "geometry" does not exist
I supposed that installing postgis I would get the geographical
object, so I am not sure if I have to do anything else.
Thanks in advance for your help,
Alvaro.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general