On 10/15/07, Lee Keel <lee.keel@uai.com> wrote:
> > -----Original Message-----
> > From: Scott Marlowe [mailto:scott.marlowe@gmail.com]
> > Sent: Monday, October 15, 2007 3:54 PM
> > To: Lee Keel
> > Cc: pgsql-general@postgresql.org
> > Subject: Re: [GENERAL] 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