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
Please sign in to leave a comment.
Hi,
Could you specify PostGIS installation schema? If you add schema where PostGIS installed for introspection it could help to resolve your problem.
Hi,
Also, read comments in the following discussion https://intellij-support.jetbrains.com/hc/en-us/community/posts/208393425-type-geometry-does-not-exist
Thank you.