Обсуждение: Case sensitivity

Поиск
Список
Период
Сортировка

Case sensitivity

От
Dana Powers
Дата:
I am evaluating whether it is possible to migrate our Contact manager
system to Postgres on Linux, but I am having difficulty because the
client software was most moronically programmed to access tables using
wildly different case structures, i.e. a table might be created
'MYTABLE', and accessed 'mytable', 'MyTable' or 'MYTABLE' depending on
the context. Is there anyway to disable case-sensitivity in this case,
either through Postgres config, or the ODBC drivers? I have no access to
re-configure the clients, due to their wonderfully closed sourcedness.
Thanks
Dana Powers
dana@fphome.com