Hey Eric. The data is in an FGDB getting prepped to go into postgres. I wrote a function in Oracle SDO to do this conversion but I don't know how to do it in either ArcGIS or Postgres. The workaround I am using now is copying the table to Oracle, converting it, copying it back to Esri, then copying it to postgres. It is pretty ugly.
Yea, I figured you were doing that. I looked through the SQL API Here but nothing stuck out at me. Thought about ST_GeomFromText in an SDE environment
"When you provide a well-known text description to construct a geometry, the measure coordinate must be specified last. For example, if your text includes coordinates for x, y, z, and m, they must be provided in that order, not x, y, m, z."
But that is not your case. Guess this has beaten the Database guys. We would use FME to do the conversion.