[postgis-users] geometry(bytea)

[Murali Maddali]

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\\0
00\\000\\000\\000\\000\\010\\247\\033\\113\\056\\263\\053\\101\\376\\053\\33
0\\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\\1
01\\213\\236\\223\\165\\164\\062\\046\\101\\010\\247\\033\\113\\056\\263\\05
3\\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)
murali.maddali at uai.com <mailto:murali.maddali at uai.com> 
 
"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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070720/91181735/attachment.html>