Thanks, it works. On Mar 23, 10:56 am, Michael Bayer <[EMAIL PROTECTED]> 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? > > > Thanks, > > Valentin.
--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---