syntax problem

Поиск
Список
Период
Сортировка
Искать

syntax problem

От:
hatem gamal elzanaty <hatem@softpro.bz>
Дата:
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
thanks in advance

Re: syntax problem

От:
Rich Shepard <rshepard@appl-ecosys.com>
Дата:
On Fri, 13 May 2011, hatem gamal elzanaty wrote:

> 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 thanks in advance

   You can find a list of postgres reserved words on the Web site. It is
comprehensive.

Rich

Re: syntax problem

От:
Chris <dmagick@gmail.com>
Дата:
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/

FAQ