Richard,<br>Thanks for this. The -launder option preserves the case. I'm resigned to having to quote all my columns in my queries because I have to preserve the schema as supplied to me.<br><br>Tim <br><br><div class="gmail_quote">
On 19 February 2010 18:02, Richard Greenwood <span dir="ltr"><<a href="mailto:richard.greenwood@gmail.com">richard.greenwood@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="im">On Fri, Feb 19, 2010 at 10:02 AM, tim mortimer<br>
<<a href="mailto:timortimer@googlemail.com">timortimer@googlemail.com</a>> wrote:<br>
> I'm experiencing a few conversion problems between MapInfo and Postgres<br>
> using ogr2ogr on WIndows:<br>
><br>
> The command ogr2ogr -f "PostgreSQL" "PG:host=xxx user=yyy dbname=db<br>
> password=zzz" table_name.tab works basically OK but I experience a number<br>
> of translation problems.<br>
><br>
> Firstly, if the original windows file name has spaces or periods(.) these<br>
> seem to act as escape char's and result in a truncated table name in<br>
> Postgres. I've tried all the combination of "" and ' ' around the file name<br>
> without success. Is there a solution to this?<br>
<br>
</div>You can define the new table name that is created with -nln<br>
"MyNewTable". Postgres tables can not have spaces, and if you want to<br>
avoid having to quote table names, you should make them all lower<br>
case.<br>
<div class="im"><br>
> Secondly, the uppercase attribute column titles are all translated to lower<br>
> case e.g. "FlowersMay" is created as "flowersmay". Is there a way of<br>
> preserving the case?<br>
<br>
</div>I don't know a work around, but personally I find this to be a feature<br>
because postgres roll everything to lowercase. If your table has a<br>
column "FlowersMay" you can not do a:<br>
SELECT FlowersMay from mytable;<br>
because postgres would see that as:<br>
SELECT flowersmay from mytable;<br>
it would have to be:<br>
SELECT "FlowersMay" from mytable;<br>
so that postgres would honor the mixed case.<br>
<br>
Rich<br>
<font color="#888888">--<br>
Richard Greenwood<br>
<a href="mailto:richard.greenwood@gmail.com">richard.greenwood@gmail.com</a><br>
<a href="http://www.greenwoodmap.com" target="_blank">www.greenwoodmap.com</a><br>
</font></blockquote></div><br>