[postgis] WKB from PostGIS over ODBC

Erik Brenn erikbrenn at hotmail.com
Mon Jul 16 05:03:01 PDT 2001

Hi all,

The PostgreSQL ODBC news group might be a better place for this but I wonder 
if there are anyone out there who know if it should be possible to use a 
Postgis function like this from an ODBC client:

select wkb_ndr(geom) where ...

>From the ODBC configuration settings I see that unknown types can be 
transferred as LongVarchar.
Basically I would like to do the query above using ODBC direct or something 
from Visual Basic, resulting in a byte array or something containing the wkb 
streams. I recon it will be faster to use this method than parsing/writing 
WKT strings on the client.

If this works I plan to write some AutoCad Map VBA classes that read and 
write GIS data from a PostgreSQL system.

Any comments?

Erik Brenn
Senior consultant
Blom International

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

------------------------ Yahoo! Groups Sponsor ---------------------~-->
Secure your servers with 128-bit SSL encryption! Grab your copy of
VeriSign's FREE Guide "Securing Your Web Site for Business." Get it now!

To unsubscribe from this group, send an email to:
postgis-unsubscribe at yahoogroups.com


Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/ 

More information about the postgis-users mailing list