On 17 December 2012 09:17, René Fournier <[email protected]> wrote: > I've aware of AddGeometryColumn(), but how can I add a geography column, a > la: > > SELECT AddGeographyColumn ('public','accounts','location',4326,'POINT',2);
Hi René, If you are using PostGIS 2+, it can be done using standard DDL, with the typmod syntax[1] to specify the geography type and SRID: ALTER TABLE accounts ADD COLUMN location geography(Point,4326); That's all! -Mike [1] http://postgis.refractions.net/docs/using_postgis_dbmanagement.html#Geography_Basics _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
