#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2008
    Posts
    209
    Rep Power
    9

    Postgre doesn't like ` vs "


    Hello, I am updating an ORM that is written for MySQL. It escapes reserved words with `. It appears that postgresql doesn't like this. Please confirm that the way to escape reserved words with postgre is only "
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Oct 2003
    Location
    Germany
    Posts
    2,784
    Rep Power
    348
    Originally Posted by imagenesis
    Please confirm that the way to escape reserved words with postgre is only "
    In Postgres and every other (standard compliant) DBMS.

    And MySQL can very well handle " for quoted identifiers if configured to be ANSI compliant.
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags.
    http://forums.devshed.com/misc.php?do=bbcode#code

    Tips on how to ask better questions:
    http://tkyte.blogspot.de/2005/06/how-to-ask-questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

IMN logo majestic logo threadwatch logo seochat tools logo