I'm trying to query my Postgres database through an ODBC data source in Windows (Excel & Access).
I've found that Excel does not like mixed case field names and the recommendation for linked SQL servers is to use all lower case names. I assume this also applies to other types of connections with the windows ODBC driver. http://www.postgresonline.com/journal/index.php?/archives/46-Setting-up-PostgreSQL-as-a-Linked-Server-in-Microsoft-SQL-Server-64-bit.html I know that there is a setting to configure the db_table in django, but I haven't found any similar setting for the field names. What approach would you recommend to address this problem. It seems that my options are: 1) rename all the fields to lower case in django and in the db 2) find a way to continue to use mixed case in my application but change the tables 3) find a way to get the ODBC driver to handle mixed cases so that everything can stay mixed case -Tim Langeman Akron, PA -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
