[postgis-users] problems with mapinfo file export to postgis

[Richard Greenwood]

On Fri, Sep 25, 2009 at 4:19 PM, Karina Guardado <kguardado at gmail.com> wrote:
> Hi all,
>
> I have exported a Mapinfo file into postgres using the following statement:
>
> ogr2ogr  -f  "PostgreSQL" -a_srs "EPSG:8913" PG:"host=localhost
> user=mysusername dbname=mydatabase password=mypass"  mytabfile.TAB
>
> but when I want to access by mapserver layer I just don't know how to make
> que query for the geometry information because I found examples using
> select the_geom from mytable
> but this work fine with a shapefile  but with mapinfo have no idea about the
> geometry part, so please if someone has an example or solution let me know

Unless you use the -nln (New Layer Name) option, ogr2ogr will name the
geometry column "wkb_geometry". So just use wkb_geometry instead of
the_geom. Hope that gets you started.

-- 
Richard Greenwood
richard.greenwood at gmail.com
www.greenwoodmap.com