I'm experiencing a few conversion problems between MapInfo and Postgres using ogr2ogr on WIndows:<br><br>The command <b>ogr2ogr -f "PostgreSQL" "PG:host=xxx user=yyy dbname=db password=zzz" table_name.tab</b> works basically OK but I experience a number of translation problems. <br>
<br>Firstly, if the original windows file name has spaces or periods(.) these seem to act as escape char's and result in a truncated table name in Postgres. I've tried all the combination of "" and ' ' around the file name without success. Is there a solution to this? <br>
<br>Secondly, the uppercase attribute column titles are all translated to lower case e.g. "FlowersMay" is created as "flowersmay". Is there a way of preserving the case?<br><br>Going the other way with <b>ogr2ogr -f "MapInfo File" new_table_name.map "PG:host=xxx user=yyy dbname=db password=zzz" "table_name"</b> again basically works OK but this time all the columns are created in the new mapinfo table in a different order than in the Postgres table. Again, is there something I've missed?<br>
<br>Thanks in anticipation,<br><br>Tim <br><br>