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


More information about the postgis-users mailing list