27

I have a shapefile that has geography types.

Can I convert it with a tool like shp2pgsql or is there a postgis function to do that?

Improve this question

2 Answers 2

Reset to default
30

You can cast the geography type to geometry by appending the ::geometry

SELECT ST_Distance('LINESTRING(-122.33 47.606, 0.0 51.5)'::geometry, 'POINT(-21.96 64.15)'::geometry);
Improve this answer
0
2

shp2pgsql has a flag to import data in a geography type column: 

shp2pgsql -G ....

But you can also import your data without it, by default shp2pgsql will create a geometry type.

Improve this answer

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.