From: Dana L. Hones <honesd@ix.netcom.com>
To: 'pgsql-interfaces@postgresql.org' <pgsql-interfaces@postgresql.org>
Subject: ECPG and case sensitivity
Date: Thu, 30 Sep 1999 15:29:25 -0400
Message-ID: <01BF0B58.94F6E7E0.honesd@ix.netcom.com> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: honesd@ix.netcom.com
Subject: Re: ECPG and case sensitivity
In-Reply-To: <01BF0B58.94F6E7E0.honesd@ix.netcom.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox