its likely a connection specific thing. do it on a Connection, then send that as "bind" to metadata.reflect().
On Jun 20, 2008, at 4:45 PM, percious wrote: > > Hey guys, > > I have a postgres database which requires me to "set search_path to > 'my_db'" before I can get a proper table listing. > > I have written a schema for this database, but what I would like to do > is compare my schema against the existing database, and make sure that > all my tables and columns jive. I have tried something like this: > > > from sqlalchemy import MetaData, create_engine > metadata = MetaData() > engine = create_engine('postgres://[EMAIL PROTECTED]/Target') > engine.execute("set search_path to 'my_db'") > metadata.bind = engine > metadata.reflect() > > print metadata.tables.keys() > > which never returns the tables I desire. > > Does anyone have any pointers? > > Thanks, > -chris > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---