On 10/15/07, Lee Keel <lee.keel@xxxxxxx> wrote: > > -----Original Message----- > > From: Scott Marlowe [mailto:scott.marlowe@xxxxxxxxx] > > Sent: Monday, October 15, 2007 3:54 PM > > To: Lee Keel > > Cc: pgsql-general@xxxxxxxxxxxxxx > > Subject: Re: Convert bytea to Float8 > > > > Does something like: > > > > select encode('12346758'::bytea,'escape')::float > > > > work? > > > > Since I'm not sure what format your data is stored in I'm just guessing > > here. > > > > Note that you could use get_byte and cycle through the offset to get > > each byte as well. > > I am sorry to say that the following line did not work. I also tried the > base64 and hex encoding types and got the same error. > select encode(esri_shape::bytea,'escape')::float > > I got the following error: > invalid input syntax for type double precision > > > The data is an ESRI blob and I am trying to convert it to a WKB to store it > in postgis. I was doing this in C# code, but I am getting a string memory > error when I get into some of my large multi-polygons. So, my solution was > to do all the byte parsing on the server. I know the standard way is to > dump to shape file and import from there, but that is too much to ask of my > client to do in this case. This is sounding more and more like a question for the postgis lists. why couldn't you load the shape file from the client side? here is one link i found discussing loading WKB files: http://osdir.com/ml/gis.postgis/2003-04/msg00067.html merlin ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
