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

[PARVEEN ARORA]

On Sat, Jul 10, 2010 at 2:37 AM, PARVEEN ARORA <parveenaroraosm at gmail.com>wrote:

> 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);
>

   the error genrated by above query is:
   *SQL error:*


     ERROR:  function addgeometrycolumn(unknown, unknown, integer,
unknown, integer) does not exist
     LINE 1: SELECT AddGeometryColumn('roads', 'geom', -1, 'GEOMETRY',2);
               ^
      HINT:  No function matches the given name and argument types.
You might need to add explicit type casts.

*      In statement:*
      SELECT AddGeometryColumn('roads', 'geom', -1, 'GEOMETRY',2);

>
> Please tell me how to create a Geometry column.
>
> With Kind Regards
> Parveen Arora
> osmpunjab.co.cc
>
>


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