Re: syntax problem

From: Chris <dmagick(at)gmail(dot)com>
To: pgsql-php(at)postgresql(dot)org
Subject: Re: syntax problem
Date: 2011-05-12 23:00:42
Message-ID: 4DCC669A.6090509@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

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/

In response to

Browse pgsql-php by date

  From Date Subject
Next Message Juan Manuel Acuña Barrera 2011-05-12 23:38:54 Fwd: syntax problem
Previous Message Rich Shepard 2011-05-12 22:49:18 Re: syntax problem