why " DROP TABLE IF EXISTS "error??

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • anaconda1977
    New Member
    • Apr 2010
    • 8

    why " DROP TABLE IF EXISTS "error??

    DROP TABLE IF EXISTS "rtp_data_excha nge";

    With this I got an error message:
    ERROR: syntax error at or near "EXISTS" at character 15

    why?
    thanks a lot!
  • rski
    Recognized Expert Contributor
    • Dec 2006
    • 700

    #2
    What postgres server version do you use?

    Comment

    • hikmat
      New Member
      • Sep 2011
      • 4

      #3
      remove quotations from the table name!

      Comment

      Working...