Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 49E96B5D8C5 for ; Thu, 12 May 2011 20:00:58 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 56346-03 for ; Thu, 12 May 2011 23:00:51 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-pw0-f46.google.com (mail-pw0-f46.google.com [209.85.160.46]) by mail.postgresql.org (Postfix) with ESMTP id CC1B9B5D8BD for ; Thu, 12 May 2011 20:00:50 -0300 (ADT) Received: by pwi15 with SMTP id 15so928527pwi.19 for ; Thu, 12 May 2011 16:00:50 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:message-id:date:from:user-agent:mime-version:to :subject:references:in-reply-to:content-type :content-transfer-encoding; bh=fWu2E3cEk0/haqWSjT38OFM87CNbMf0S8CgPvvnKvhw=; b=qIvBRprL8G/bQTwCbQjWABqwzeijNiE7PrfSWBvYvIhprCiLVhstvXNAK9NMM1zyR+ O0m0B4coSOggR0S7aGwHsSD9j5MOVqGxZLUjS2Uly3nHRVspfE3X9S+jbxsqqvYRnUTX 6u083tJMXcopIN6In97pcvIH6h/5g5NGIitt4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:subject:references :in-reply-to:content-type:content-transfer-encoding; b=QJUQDNe9NUTr0P+Z4tj3rYb2I6xp72NLe7b5fKvCaYfYVwHHLv8ssIaT9+P9Wf7Zx6 Ktn5kh/h2esmu2NDD5w0dRMNyR7zoFaWx8rYHzzwhdPpg5LJMU5uc0n+oEy1UNC5d/rF LRbAp6vcOJ+6doTjR/fL7AB6Bof6HTLAKZoLU= Received: by 10.142.152.35 with SMTP id z35mr406417wfd.166.1305241250627; Thu, 12 May 2011 16:00:50 -0700 (PDT) Received: from [192.168.2.65] (ppp234-39.static.internode.on.net [59.167.234.39]) by mx.google.com with ESMTPS id p10sm1553918wfl.9.2011.05.12.16.00.46 (version=TLSv1/SSLv3 cipher=OTHER); Thu, 12 May 2011 16:00:48 -0700 (PDT) Message-ID: <4DCC669A.6090509@gmail.com> Date: Fri, 13 May 2011 09:00:42 +1000 From: Chris User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.17) Gecko/20110424 Thunderbird/3.1.10 MIME-Version: 1.0 To: pgsql-php@postgresql.org Subject: Re: syntax problem References: <4DCC4C80.1070705@softpro.bz> In-Reply-To: <4DCC4C80.1070705@softpro.bz> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.888 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RFC_ABUSE_POST=0.001, T_TO_NO_BRKTS_FREEMAIL=0.01 X-Spam-Level: X-Archive-Number: 201105/3 X-Sequence-Number: 4208 On 13/05/11 07:09, hatem gamal elzanaty wrote: > hi, > i'm a php/mysql developer and want to work also with php/postgresql can > you please tell me if there is a replacment for this sign ` in mysql to > work with in postgresql to avoid problem of naming tables with reseved > words You can put double quotes around them but you have to do it all the time so if you can, I'd suggest renaming the fields and tables to avoid those words in the first place. The list Rich mentioned is here: http://www.postgresql.org/docs/current/static/sql-keywords-appendix.html -- Postgresql & php tutorials http://www.designmagick.com/