Received: from pimout1-int.prodigy.net (pimout1-ext.prodigy.net [207.115.63.77]) by hub.org (8.10.1/8.10.1) with ESMTP id e6FHmg088593 for ; Sat, 15 Jul 2000 13:48:42 -0400 (EDT) Received: from prodigy.net (NYCMA050-0661.splitrock.net [63.253.68.153]) by pimout1-int.prodigy.net (8.8.5/8.8.5) with ESMTP id NAA83148; Sat, 15 Jul 2000 13:48:36 -0400 Message-ID: <3970A354.16F3212A@prodigy.net> Date: Sat, 15 Jul 2000 13:45:56 -0400 From: EDWARD POTTER Reply-To: ejp@well.com X-Mailer: Mozilla 4.61 [en] (WinNT; I) X-Accept-Language: en,pdf MIME-Version: 1.0 To: Matthias Meyer CC: pgsql-php@postgresql.org Subject: Re: case sensitiv table and column names References: <00071514512700.01910@AthLux.telekabel.at> Content-Type: multipart/mixed; boundary="------------788F7FBD88AC0963B0852043" X-Archive-Number: 200007/3 This is a multi-part message in MIME format. --------------788F7FBD88AC0963B0852043 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Is there any reason why u can't use kunden? I guess since PHP is open source [and so is Postgres] u could probably hack that code on your own to accept either upper or lower case names. On the other hand, maybe there is a simpler solution, but I have not yet stumbled on it... !ed > Hallo Mailinglist > > If I use PostgreSQL from PHP3 with pg_exec($db,"SELECT * FROM > Kunden"); I get an error like "Warning: PostgresSQL query failed: ERROR: > kunden: Table does not exist." > Thats right because the table called "Kunden" with an upper K. > > What should I do that PHP/PostgreSQL accept case sensitiv table names ? > > :-)Matthias --------------788F7FBD88AC0963B0852043 Content-Type: text/x-vcard; charset=us-ascii; name="ejpusa.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for EDWARD POTTER Content-Disposition: attachment; filename="ejpusa.vcf" begin:vcard n:Potter;Edward x-mozilla-html:FALSE adr:;;;;;; version:2.1 email;internet:ejp@well.com fn:Edward Potter end:vcard --------------788F7FBD88AC0963B0852043--