pg.ddx.io pgsql-php@postgresql.org mailing list archive
help / color / mirror / Atom feedsyntax problem
4+ messages / 4 participants
[nested] [flat]
* syntax problem
@ 2011-05-12 21:09 hatem gamal elzanaty <hatem@softpro.bz>
0 siblings, 2 replies; 4+ messages in thread
From: hatem gamal elzanaty @ 2011-05-12 21:09 UTC (permalink / raw)
To: pgsql-php
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: syntax problem
@ 2011-05-12 22:49 Rich Shepard <rshepard@appl-ecosys.com>
parent: hatem gamal elzanaty <hatem@softpro.bz>
1 sibling, 0 replies; 4+ messages in thread
From: Rich Shepard @ 2011-05-12 22:49 UTC (permalink / raw)
To: pgsql-php
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: syntax problem
@ 2011-05-12 23:00 Chris <dmagick@gmail.com>
parent: hatem gamal elzanaty <hatem@softpro.bz>
1 sibling, 0 replies; 4+ messages in thread
From: Chris @ 2011-05-12 23:00 UTC (permalink / raw)
To: 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/
^ permalink raw reply [nested|flat] 4+ messages in thread
* Fwd: syntax problem
@ 2011-05-12 23:38 Juan Manuel Acuña Barrera <gps1mx@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: Juan Manuel Acuña Barrera @ 2011-05-12 23:38 UTC (permalink / raw)
To: pgsql-php
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Inicio del mensaje reenviado:
> De: Juan Manuel Acuña Barrera <gps1mx@gmail.com>
> Fecha: 12 de mayo de 2011 17:59:28 CDT
> Para: hatem gamal elzanaty <hatem@softpro.bz>
> Asunto: Re: [PHP] syntax problem
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
>
> El 12/05/2011, a las 16:09, hatem gamal elzanaty escribió:
>
>> 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@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-php
>
> Hi.
>
> I am also a php / mysql developer, and I'm starting with postgres. I highly recommend you do not use the quotes or reserved words. I had many problems by insisting on using them.
>
> Good luck.
>
> Juan Manuel.
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG/MacGPG2 v2.0.14 (Darwin)
>
> iEYEARECAAYFAk3MZlQACgkQTc4QiYN6hDfHiwCeOMR0lXoFw7b2LANFGP23Q4ln
> ElgAoKBHAbHXEk55LzhAUKeNUXR8KdlJ
> =LyDT
> -----END PGP SIGNATURE-----
Sorry, accidentally sent it to the personal email instead of to the list.
Good luck.
Juan Manuel.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG/MacGPG2 v2.0.14 (Darwin)
iEYEARECAAYFAk3Mb5EACgkQTc4QiYN6hDc8SACgoICdOBCDYo2ful6mLSnT6YLX
+1UAnAl7mYJ3OHN3EXNWfiR9MqlRCE2c
=oeom
-----END PGP SIGNATURE-----
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2011-05-12 23:38 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-05-12 21:09 syntax problem hatem gamal elzanaty <hatem@softpro.bz>
2011-05-12 22:49 ` Rich Shepard <rshepard@appl-ecosys.com>
2011-05-12 23:00 ` Chris <dmagick@gmail.com>
2011-05-12 23:38 Fwd: syntax problem Juan Manuel Acuña Barrera <gps1mx@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox