Syntax for Extension Types: I'm using the POSTGIS ...
# help
n
Syntax for Extension Types: I'm using the POSTGIS extension to add geometric types to my database but I'm not sure what the syntax is for creating new rows. I've tried both
{"x": 1, "y": 1}
and
POINT(1,1)
as values but I always get the following error:
Copy code
postgrest_py.exceptions.APIError: {'message': 'invalid input syntax for type point: "<THE VALUE>"', 'code': '22P02', 'details': None, 'hint': None}
It's the same in the web interface
g
I use format "POINT(0 0)" from js api. I actually use "SRID=4326;POINT(" + geo.coords.long + " " + geo.coords.lat + ")"
n
That didn’t work for me (in python and web ui) But I’ve since found that using
(x,y)
works 👍