Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 498D7634029 for ; Tue, 12 Jan 2010 15:07:31 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 67641-06-5 for ; Tue, 12 Jan 2010 19:07:20 +0000 (UTC) X-Greylist: delayed 00:09:38.980161 by SQLgrey-1.7.6 Received: from smtp27.orange.fr (smtp27.orange.fr [80.12.242.94]) by mail.postgresql.org (Postfix) with ESMTP id 53A2E633AA6 for ; Tue, 12 Jan 2010 15:06:02 -0400 (AST) Received: from me-wanadoo.net (localhost [127.0.0.1]) by mwinf2728.orange.fr (SMTP Server) with ESMTP id 885801C00107 for ; Tue, 12 Jan 2010 19:56:19 +0100 (CET) Received: from me-wanadoo.net (localhost [127.0.0.1]) by mwinf2728.orange.fr (SMTP Server) with ESMTP id 7AAB11C0021D for ; Tue, 12 Jan 2010 19:56:19 +0100 (CET) Received: from buck.readysoft67 (LPuteaux-156-16-23-3.w82-127.abo.wanadoo.fr [82.127.38.3]) by mwinf2728.orange.fr (SMTP Server) with ESMTP id 4FF261C00107 for ; Tue, 12 Jan 2010 19:56:19 +0100 (CET) X-ME-UUID: 20100112185619330.4FF261C00107@mwinf2728.orange.fr From: Nadine Mauch To: pgsql-php@postgresql.org Subject: Capitalized Databases and columns names Date: Tue, 12 Jan 2010 19:56:01 +0100 User-Agent: KMail/1.6.2 Organization: ReadySOFT Sarl MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="iso-8859-15" Content-Transfer-Encoding: 7bit Message-Id: <201001121956.01058.nadine.mauch@laposte.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.189 tagged_above=-10 required=5 tests=BAYES_50=0.001, FH_DATE_PAST_20XX=3.188 X-Spam-Level: *** X-Archive-Number: 201001/1 X-Sequence-Number: 4099 ref : PHP5 and postgresql 8.1 Hello, For reasons of lisibility I've created DataBases and Table Columns with capitalized names. To access databases in php code I just use double cotes as delimiters for names in sql requests. I compose on-demand requests with concatened php strings. The result is for example : select "TCRtimestp" from "TrcDFCR" where "TCRtimestp"=20060228113419 ; Such requests are manageable thru concatenation but I get problems with functions like select nextval ('TCRnrordre') ; where the request becomes select nextval ('trcnrordre') ; where everything is in lowercase and the result is : relation tcrnrordre does not exist. select nextval ('"TCRnrordre"') ; is not possible due to syntax error. I just don't achieve nor in php nor in psql to get the next value because of this capitalize problem. Does someone know if there is a solution or if I have to use only lowercase caracters ? Thanks. Nadine