ECPG and Table/Field name case sensitivity - Mailing list pgsql-interfaces

From Dana L. Hones
Subject ECPG and Table/Field name case sensitivity
Date
Msg-id 01BF0B66.7055BCA0.honesd@ix.netcom.com
Whole thread Raw
List pgsql-interfaces
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.



pgsql-interfaces by date:

Previous
From: John Cusick
Date:
Subject: Re: [INTERFACES] PL_na undeclared
Next
From: Lamar Owen
Date:
Subject: Re: [INTERFACES] PL_na undeclared