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 mkmo...@gmail.com wrote:
> Using a `.` in a table name will cause the table name to be
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