[OSM-dev] [OSM-Dev]Add Geometry Column in PostgreSQl

[PARVEEN ARORA]

Dear List,
Hi

I am unable to create a Geometry table in phpPgAdmin

Firstly i have given the following query to create a table:

 CREATE TABLE roads (id INT4, name VARCHAR(128));

It was successful and has create two columns.
But when i tried to add a coulmn of geometry by following query its not
working.

SELECT AddGeometryColumn('roads', 'geom', -1, 'GEOMETRY',2);

Please tell me how to create a Geometry coulmn

With Kind Regards
Parveen Arora
osmpunjab.co.cc
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20100710/f4a8a186/attachment.html>