What is the proper type for columns holding GeoJSON?
What is the proper type for columns holding GeoJSON?


In PostgreSQL, as JSONB (ideally), or JSON.


  Which is the proper way of migrating data held in Oracle spatial in production to PostGIS?


As "Well-Known Binary", (WKB) using Get_WKB. Or simply using oracle_fdw which solves most of these problems and uses WKB behind the scenes.


  The only supported geometry types are POINT, LINE, POLYGON, MULTIPOINT, MULTILINE and MULTIPOLYGON in two and three dimensions. Empty PostGIS geometries are not supported because they have no equivalent in Oracle Spatial.


Moreover on the subject of GeoJSON, PostGIS provides ST_GeomFromGeoJSON, and ST_AsGeoJSON if you want to use GeoJSON.