Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id BBDB263381D for ; Mon, 27 Apr 2009 17:02:26 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 49574-01 for ; Mon, 27 Apr 2009 17:02:24 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail49.e.nsc.no (mail49.e.nsc.no [193.213.115.49]) by mail.postgresql.org (Postfix) with ESMTP id 3DE0063373D for ; Mon, 27 Apr 2009 17:02:23 -0300 (ADT) Received: from [192.168.0.15] (062016185042.customer.alfanett.no [62.16.185.42]) (authenticated bits=0) by mail49.nsc.no (8.13.8/8.13.5) with ESMTP id n3RK2KPc014885 for ; Mon, 27 Apr 2009 22:02:21 +0200 (MEST) From: "Leif B. Kristensen" To: pgsql-php@postgresql.org Subject: Re: Newbie Question-Quoting SQL Date: Mon, 27 Apr 2009 22:02:19 +0200 User-Agent: KMail/1.9.9 References: In-Reply-To: X-Face: %iea8o"[SI'kMDS.`hz7lU=?\^lC9J-]CVjo; f{4-C:$?uVUEjyN~uYFn%*aH_c3d09U>=?utf-8?q?x=0A=09TXtaoj=7EMV=2E8PgG7hik9=3BcCT2N6+u?=@Y{wH\p3*_f~FH9k,Wi74e[_l%.7b^'zJ)8S'^G<(=?utf-8?q?=3D=0A=09zw8=5CPMC3=27=7BKl9=2EzL*ks!b6wA?=,c~'F`k&Vq|ELDGa|4 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200904/14 X-Sequence-Number: 4019 On Monday 27. April 2009, Thomas Hart wrote: > $result = pg_query ($link, "Select * from Author"); If the table really is named "Author" with a capital A, you'll need to quote it, because postgres will fold it to lowercase otherwise. -- Leif Biberg Kristensen | Registered Linux User #338009 Me And My Database: http://solumslekt.org/blog/