Skip to main content
Question

Storing CAD data in postgres FME Cloud

  • March 24, 2018
  • 1 reply
  • 6 views

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

1 reply

takashi
Evangelist
  • March 24, 2018

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;

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings