[postgis-users] AddGeometryColumn error

Nicolas Ribot nicky666 at gmail.com
Wed Aug 27 03:47:29 PDT 2008


> First of all, Postgres display me the next error with this query:
>
> My database is named postgres
> My table is named estac_aemet
> The name of the new column I want to create is the_geom
> 23030 is UTM-ED50 huso 30 (Proyection I want)
>
> SELECT addgeometrycolumn('postgres','estac_aemet', 'the_geom', 23030,'POINT',2)
>

the first parameter is expected to be the schema name (default
'public' schema in your case, probably).
command should be:

SELECT addgeometrycolumn('public','estac_aemet', 'the_geom', 23030,'POINT',2)

nicolas



More information about the postgis-users mailing list