I installed Postgres 9.5. Then I installed PostGIS. Then I created database named
geodb. In it I created column with type
polygon and several others like
polygon was created successfully, so it's seems that PostgreSQL know about geometry.
But when I am trying to run next query:
INSERT INTO public.rasters_previews(
id, "Path", "Coordinates", "Name", "imageBounds")
VALUES (1, 'foo', ST_GeomFromText('polygon((60.536 27.589,60.509 39.054,54.908 38.183,54.93 28.368,60.536 27.589))'), 'xname', 'xbound');
I am getting error that function
ST_GeomFromText does not exists.
I tried to do same with setting
postgis_22_sample as template but got same result.
What I am doing wrong? Should I do any other manipulation to get DB wotk as geospatial?