[GRASS-user] RE: Problem querying layers other than '1' in gi s.m
Patton, Eric
epatton at nrcan.gc.ca
Mon Sep 25 11:14:35 EDT 2006
>> Could the error I'm getting be caused by the length of the new field
>>names?
>I think the problem is rather the period in the name.
>From the Postgresql documentation:
>"SQL identifiers and key words must begin with a letter (a-z, but also
>letters with diacritical marks and non-Latin letters) or an underscore
>(_). Subsequent characters in an identifier or key word can be letters,
>underscores, digits (0-9), or dollar signs ($)."
>Moritz
Strange then that Sqlite writes these column names itself?! I exported the
tables as csv, opened it in OOffice, and just renamed the columns. It seems
to be behaving now.
Thanks,
~ Eric.
More information about the grass-user
mailing list