title: How to insert SQL Server geometry data to postgis geometry data type column
body: <p>We have data in our SQL Server of <code>geometry</code> datatype.</p>
  <p>When doing</p>
  <pre><code>select shape 
  from boundary_polygon
  </code></pre>
  <p>I get this result:</p>
  <p><a href="https://i.stack.imgur.com/f5YOz.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/f5YOz.png" alt="enter image description here" /></a></p>
  <p>I have exported the data from SQL Server from the table shown here. How can I import the same data into postgres with datatype <code>geometry</code> for the below is the table structure. As the data in the <code>shape</code> column is in hexadecimal, how to import?</p>
  <pre><code>create table boundary_polygon(id int, shape geometry)
  </code></pre>