We have some tables created with qoutes in postgre...
# exposed
g
We have some tables created with qoutes in postgres, thus case sensitive, but exposed seems to make the table name lowercase even if it is in quotes (https://github.com/JetBrains/Exposed/issues/1658), is there any existing workaround?
When using it with schema prefix:
Copy code
(name = "\"schema.Table\"")
Generates
Copy code
""schema"."Table""
And
Copy code
(name = "schema.\"Table\"")
Generates
Copy code
schema."table"
So the first one does not lowercase the tablename, but it is incorrect sql. Secound one makes a lowercase, probably because I have a schema prefix?
For anyone else having the same issue: https://github.com/JetBrains/Exposed/issues/1710
s
Have you tried the workaround described in the issue?
g
Indeed I have, I wrote it. 🙂
😅 1
👍 1