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

1
2 comments

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

0

Please sign in to leave a comment.