Skip to main content
  • EN

I am trying to add geometry columns to a postgres instance on FME Cloud and I am getting this error.

ERROR: function addgeometrycolumn(unknown, unknown, unknown, integer, unknown, integer) does not exist
LINE 35: SELECT AddGeometryColumn('cad_qa','WATERLINES','geom',2277,'...

Here is the select statement, it is from an FMEpedia github project,

SELECT AddGeometryColumn('cad_qa','WATERLINES','geom',2277,'LINESTRING',2);

Hi @garydlester, most likely you have not yet added PostGIS extensions to the database.
If so, try executing these statements first to add the extensions.

create extension postgis;
create extension postgis_topology;

Reply


Community Stats

30,108
Posts
114,284
Replies
37,742
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.