GEOMETRY Data Type - SQL Server to PostgreSQL Migration

SQL Server and PostgreSQL provide GEOMETRY data type that stores spatial data. Note that you have to install and enable PostGIS extension to use GEOMETRY data type in PostgreSQL.

SQL Server and PostgreSQL:

  -- Sample table 
  CREATE TABLE geo 
  (
     geodata GEOMETRY
  );
 
  -- Inserting sample value
  INSERT INTO geo VALUES ('POLYGON ((-72 -21, -70 -18, -69 -17, -72 -21))');

For more information, see SQL Server to PostgreSQL Migration.