syntax problem

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

--
Sent via pgsql-php mailing list (pgsql-php [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php
hatem gamal elzanaty [ Do, 12 Mai 2011 23:09 ] [ ID #2059459 ]

Re: syntax problem

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

--
Sent via pgsql-php mailing list (pgsql-php [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php
Rich Shepard [ Fr, 13 Mai 2011 00:49 ] [ ID #2059460 ]

Re: syntax problem

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-a ppendix.html

--
Postgresql & php tutorials
http://www.designmagick.com/


--
Sent via pgsql-php mailing list (pgsql-php [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php
dmagick [ Fr, 13 Mai 2011 01:00 ] [ ID #2059461 ]
Datenbanken » gmane.comp.db.postgresql.php » syntax problem

Vorheriges Thema: Fwd: syntax problem
Nächstes Thema: Connecting PHP-based Application to Postgres-9.0.3