Received: from icebox.venux.net (icebox.venux.net [216.120.166.10]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f15Hbux39512 for ; Mon, 5 Feb 2001 12:37:56 -0500 (EST) (envelope-from mitch@venux.net) Received: from windows (mdmmi096064.voyager.net [216.93.96.64]) by icebox.venux.net (Postfix) with SMTP id BA1A526209; Mon, 5 Feb 2001 12:48:34 -0500 (EST) Message-ID: <011001c08f9a$5065d380$0200000a@windows> From: "Mitch Vincent" To: , , "Julio Cuz, Jr." References: <4.3.2.7.2.20010205084023.036ddee8@rccd.cc.ca.us> Subject: Re: Lowercase problem Date: Mon, 5 Feb 2001 12:37:29 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200102/2 X-Sequence-Number: 141 Try quoting your table names. SELECT * FROM "WHATEVER"; -Mitch ----- Original Message ----- From: "Julio Cuz, Jr." To: ; Sent: Monday, February 05, 2001 12:25 PM Subject: [PHP] Lowercase problem > Hi-- > > I don't know where the problem resides, but when I call a table or a field > name from Postgresql using PHP4, it treats the string ALL LOWERCASE, so I > get an error about 'field/table not relational..." do you know where the > problem is? > > P.S. Some tables have upper and lowercase, as well as field names...I had > to transfer everything to lowercase to get it working. > > Julio Cuz, Jr. > Riverside Community College > jcuz@rccd.cc.ca.us > >