Received: from mail.fiber.net (root@mail.fiber.net [216.83.130.4]) by hub.org (8.10.1/8.10.1) with ESMTP id e6FKIp022710 for ; Sat, 15 Jul 2000 16:18:51 -0400 (EDT) Received: from dwilson (bbudnick.employees.fiber.net [216.83.131.7]) by mail.fiber.net (8.9.3/8.9.3) with ESMTP id OAA06106 for ; Sat, 15 Jul 2000 14:18:46 -0600 (MDT) Message-ID: <002701bfee99$74b529e0$a65bfea9@dwilson> Reply-To: "Dan Wilson" From: "Dan Wilson" To: References: <00071514512700.01910@AthLux.telekabel.at> Subject: Re: case sensitiv table and column names Date: Sat, 15 Jul 2000 14:15:38 -0600 MIME-Version: 1.0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6600 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 X-Archive-Number: 200007/4 Just put Kunden in quotes: pg_exec($db,"SELECT * FROM \"Kunden\""); -Dan ----- Original Message ----- From: "Matthias Meyer" To: Sent: Saturday, July 15, 2000 6:45 AM Subject: case sensitiv table and column names > 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