I'm having 2 questions.
In my remote database a column is created as; alter table MYTABLE add column geog geography
. Basically it's PostGIS extension for Postgres. With this said, i want MapBox to add the location coordinates from the map to this column. I wish i could save the name of selected point into my table. If it's hard, i could save coordinates to my db. How do i save this MapBox data (long and latitude) to my column geog. Or is there a better way?
Thanks for reading
Hey @ltfrupdt!
I'm not super familiar with this PostGIS extension but since it's an issue of passing an extended data type to your DB I wonder if disabling prepared statements on your query will help so that the query is passed exactly as constructed. Can you let me know if that works?