SQLite supports an "ATTACH" command where multiple databases may be accessed seamlessly using a single connection. Does PostgreSQL have something similar? If so, then perhaps all you'd need is to add a few extra steps when you connect to the database.
Barry ----- Original Message ---- From: Alchemist <[EMAIL PROTECTED]> To: sqlalchemy <[email protected]> Sent: Wednesday, May 30, 2007 9:19:09 AM Subject: [sqlalchemy] how to retrieve/update data from/on multiple databases Working with: Python 2.4 SQLAlchemy 0.3.7 Postgresql 8.2 database servers I am working in a multidatabase environment. I need to perform a query over multiple databases, then manipulate the obtained results and commit my changes in different tables in different databases. How can I query from multiple databases? How can INSERTs/UPDATEs be performed on different tables in different databases? Thank you. ____________________________________________________________________________________ Park yourself in front of a world of choices in alternative vehicles. Visit the Yahoo! Auto Green Center. http://autos.yahoo.com/green_center/ --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
