Doctrine ORM table with schema annotation

Question

Schema and table name in Postgres are case sensitive. How can I specify correct schema in docblock annotations so they are not converted to lowercase?

Neither of these works:

@Table(name="MySchema.MyTable") // gets converted to lowercase
@Table(name="`MySchema`.`MyTable`") // invalid table
@Table(name="`MySchema.MyTable`") // also invalid table

Doctrine ORM is 2.0.4

Theres no word about schema in documentation either, only found that schema param/keyword is no longer supported.

possible duplicate of [Case problem with doctrine2, symfony2 and postgresql entities](http://stackoverflow.com/questions/5573865/case-problem-with-doctrine2-symfony2-and-postgresql-entities) — Ross, May 12 '11 at 11:51

score 3 · Accepted Answer · edited May 23 '17 at 11:45

3

As mentioned in this thread, Postgres is case-sensitive and each word must be escaped:

@Table(name="""MySchema"".""MyTable""")

edited May 23 '17 at 11:45

Community

1
1

answered May 19 '11 at 17:23

Ross

46,186
39
120
173

Doctrine ORM table with schema annotation

1 Answers1