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.
As mentioned in this thread, Postgres is case-sensitive and each word must be escaped:
@Table(name="""MySchema"".""MyTable""")
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With