Received: from dfw-ix7.ix.netcom.com (dfw-ix7.ix.netcom.com [206.214.98.7]) by hub.org (8.9.3/8.9.3) with ESMTP id PAA87585 for ; Thu, 30 Sep 1999 15:33:33 -0400 (EDT) (envelope-from honesd@ix.netcom.com) Received: (from smap@localhost) by dfw-ix7.ix.netcom.com (8.8.4/8.8.4) id OAA05886 for ; Thu, 30 Sep 1999 14:32:58 -0500 (CDT) Received: from h12-20-42-113.chubb.com(12.20.42.113) by dfw-ix7.ix.netcom.com via smap (V1.3) id rma005871; Thu Sep 30 14:32:32 1999 Received: by localhost with Microsoft MAPI; Thu, 30 Sep 1999 15:29:27 -0400 Message-ID: <01BF0B58.94F6E7E0.honesd@ix.netcom.com> From: "Dana L. Hones" Reply-To: "honesd@ix.netcom.com" To: "'pgsql-interfaces@postgresql.org'" Subject: ECPG and case sensitivity Date: Thu, 30 Sep 1999 15:29:25 -0400 X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211 Encoding: 19 TEXT 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.