I never use postgress, but if you don´t planinig to make joins with tables on diferente schemas you could modify a propel generetor in order to use the schema.tablename in the Peer::TABLE_NAME constant so in any mention of the table you will get schema.table_name instace of table_name.
On Thu, Apr 10, 2008 at 10:16 AM, Reynier Perez Mira <[EMAIL PROTECTED]> wrote: > > Hi every: > > > Define "multiple schemas". > > What you mean with "define multiples schemas"? I understand by "schema" at > least in PostgreSQL (the SGBD I use in my project now) a set of objects > (tables, views, indexes, etc) that belongs to an user account and as Oracle > Wiki [1] said It is often used as another way to refer to an Oracle account. > I want to use having a set of tables in the same PostgreDB. For example: > > db: mydatabase > schema: projects > tables: table1 > table2 > schema: accounts > tables: users > users_preferences > > ¿Understand now? I can't deal with that using Symfony or better using Propel > because this last doesn't support schemas yet. I don't know if for future > versions Propel come with this feature. Also I don't know if Doctrine support > this. ¿Any know? > > > > We are building several apps in ONE symfony tree and successfully > > using several schemas and several databases within the same database > > server. > > As I explain befote maybe you use schemas as Oracle account and not as > multiples schemas in the same DB. > > [1] http://orafaq.com/wiki/Schema > > ¿Another approach? > > Cheers and thanks in advance > Ing. Reynier Pérez Mira > Grupo Soporte al Desarrollo - Dirección Técnica IP > > > __________ Information from ESET NOD32 Antivirus, version of virus signature > database 3015 (20080410) __________ > > The message was checked by ESET NOD32 Antivirus. > > http://www.eset.com > > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony users" 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/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---
