Thanks,
it works.
On Mar 23, 10:56 am, Michael Bayer <mike...@zzzcomputing.com> wrote:
dont stick "foo.bar" in your table name. use the schema="DBNAME"
parameter on your Table.
On Mar 23, 2007, at 9:41 AM, vkuznet wrote:
Hi,
I've got a new DB to handle and the account is setup in a way that I
need to specify dbname for selects, e.g. select * from DBNAME.T
So, I created a table
T=Table('DBNAME.T'....)
and once I used it
res=select([T]).execute()
the sqlalchemy constructed the following query with *quotes*
select "DBNAME.T".id from "DBNAME.T"
the problem is that ORACLE doesn't accept it, but if I manually drop
*quotes* from this select and pass it to sqlplus everything works,
i.e.
select DBNAME.T.id from DBNAME.T
How to disable *quoting* for SQLAlchemy?
3 messages in com.googlegroups.sqlalchemy[sqlalchemy] Re: ORACLE db name in ta...