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 [email protected]
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
-~----------~----~----~----~------~----~------~--~---
