PostGIS commands returns error in datagrip

I've a PostgreSQL database with PostGIS installed. The following command works fine when executed in pgAdminIII, but throws an error when executed in Datagrip. Any ideas?


CREATE TABLE data.points(
id serial,
typ_id integer

SELECT AddGeometryColumn ('data','points','geom' ,2056 ,'POINT' ,2, true);


The error recieved: [42883] ERROR: function addgeometrycolumn(unknown, unknown, unknown, integer, unknown, integer, boolean) does not exist Hinweis: No function matches the given name and argument types. You might need to add explicit type casts. Position: 8


Could you specify PostGIS installation schema? If you add schema where PostGIS installed for introspection it could help to resolve your problem.


Please sign in to leave a comment.