Using a `.` in a table name will cause the table name to be quoted.
For example:
from sqlalchemy import table, column
t = table('myschema.mytable', column('id'))
print(select(t.c.id))
Outputs:
SELECT "myschema.mytable".id
FROM "myschema.mytable"
This fails in Oracle because the table name within the quotes is not in all
caps.
How can I remove the quotes and instead have it render:
SELECT myschema.mytable.id
FROM myschema.mytable
Thanks and best regards,
Matthew
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
http://www.sqlalchemy.org/
To post example code, please provide an MCVE: Minimal, Complete, and Verifiable
Example. See http://stackoverflow.com/help/mcve for a full description.
---
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/sqlalchemy/2827f031-6f9a-4124-9c85-2f30c6b5e337n%40googlegroups.com.
