My apologies, I just saw that I can use the schema key word for this case:
t = table('mytable', column('id'), schema='myschema')
Best regards,
Matthew
On Friday, June 17, 2022 at 11:13:44 AM UTC-7 [email protected] wrote:
> 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/d68b348b-972b-48da-8eba-616b17972a83n%40googlegroups.com.
