What is the format of your bytea? If it's the ESRI shape file
record, untranslated, you're out of luck. If it's a WKB byte array,
then use GeomFromWKB.
P
On 20-Jul-07, at 8:17 AM, Murali Maddali wrote:
Hello All,
Can any one tell what I am doing wrong with the following select.
select geometry('\\005\\000\\000\\000\\010\\247\\033\\113\\056\\263\
\053\\101\\213\\236\\223\\165\\164\\062\\046\\101\\006\\377\\131\
\025\\172\\266\\053\\101\\350\\300\\323\\152\\241\\067\\046\\101\
\001\\000\\000\\000\\006\\000\\000\\000\\000\\000\\000\\000\\010\
\247\\033\\113\\056\\263\\053\\101\\376\\053\\330\\300\\234\\067\
\046\\101\\205\\364\\147\\256\\134\\266\\053\\101\\350\\300\\323\
\152\\241\\067\\046\\101\\006\\377\\131\\025\\172\\266\\053\\101\
\230\\025\\330\\025\\171\\062\\046\\101\\034\\227\\351\\330\\331\
\263\\053\\101\\366\\105\\154\\104\\165\\062\\046\\101\\136\\376\
\167\\260\\113\\263\\053\\101\\213\\236\\223\\165\\164\\062\\046\
\101\\010\\247\\033\\113\\056\\263\\053\\101\\376\\053\\330\\300\
\234\\067\\046\\101\\000'::bytea);
I am trying to convert a ESRI shape which is stored as a blob in
SQL Server 2000 to postgis. I am using Npgsql to connect to
postgis. This is the out I got from Npgsql. I know this is a valid
shape and when I imported the data using shp2pgsql from the shape
file it imported fine.
Thank you,
Regards,
Murali K. Maddali
UAI, Inc.
(256) 705-5191 (W)
[EMAIL PROTECTED]
"Always bear in mind that your own resolution to succeed is more
important than any one thing." - Abraham Lincoln
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom
they are addressed. If you have received this email in error please
notify the sender. This message contains confidential information
and is intended only for the individual named. If you are not the
named addressee you should not disseminate, distribute or copy this
e-mail.
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
