Обсуждение: ECPG and Table/Field name case sensitivity

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

ECPG and Table/Field name case sensitivity

От
"Dana L. Hones"
Дата:
Hello,

I have a PostgreSQL DB on Linux that I copied over from MS Access.  Thus, I 
have mixed case table and field names.  I can access the database from PSQL 
in the following manner:
select * from "Namelist" where "NameID" = 1234;

How may I accomplish the same thing while using ECPG under C?  ECPG ignores 
the quotes and converts the table and field names to lower case.  I tried 
editing the output "C" file from ECPG and now the C complier complains 
about the syntax.

Any help would be greatly appreciated.

DLH

Dana L. Hones
Hones MacDonald, Inc.