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);
+17
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;
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.