Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have spatial Data stored in my PostgreSQL database as PostGIS Geometry (PG_GEOMETRY). It looks for example like this: 010100002031BF0D0000000000F989264152B81E057E6D5841

Now I would like to move this column to a database with ArcSDE schema, which uses ST_GEOMETRY.

Is this possible with a simple sql command, or a more difficult task?

share|improve this question
up vote 1 down vote accepted

Export the geometry to eWKB/WKB or WKT and then import it in the other db using appropiate function for geometry from eWKB/WKB/WKT. For example for WKB use ST_AsBinary and ST_SRID in PostGIS.

share|improve this answer
Thanks for the answer, this worked extracting the PostGIS geometry column with ST_AsText and inserting it into the spatial column of a feature class with sde.st_geometry. – Nicolas Caspari May 16 '13 at 7:16

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.