Will this actually create the schema, though? Or will that have to be done manually, with Django managing the tables inside the schemas I create myself?
Thanks! Jon Brisibn http://jbrisbin.com On Jul 11, 2008, at 9:01 AM, Scott Moonen wrote: > Hi Jon. I believe you can use the Django model meta property > db_table to specify the schema. According to ticket #6064 you need > to use somewhat hackneyed syntax at the moment (notice the outer > single quotes and the explicit inner double quotes): > > class MyModel(models.Model) : > . . . > > class Meta : > db_table = '"accounting"."mymodel"' > > It looks like ticket #6064 addresses putting schemas into your > search order for search purposes, but not explicitly specifying > schemas for lookup or table creation. Unless the PostgreSQL quote > function is made smarter before 1.0, it's probably a good idea for > you to continue to use this syntax. > > > -- Scott > > On Fri, Jul 11, 2008 at 9:50 AM, Jon Brisbin <[EMAIL PROTECTED]> > wrote: > > I hardly ever put anything in the Postgres "public" schema except for > things I want exposed to all applications and tables within a > database. I usually segregate the tables into schemas based on their > relationship to one another. With several hundred tables in the > database, this gets pretty critical. I noticed Django doesn't have any > explicit schema support, but instead uses app prefixes. I realize that > some would argue that's functionally equivalent. But not when you're > looking at all those tables in pgAdmin. > > Would it be difficult to add schema support for those databases that > support it rather than using the app_table naming methodology? Just > create a schema called "app" and then the table named after the model. > I guess it's really a personal preference, but I'm used to working > with schemas because of the large number of tables in our warehouse. > Maybe we're unusual in how heavily we rely on Postgres, but it's a > convention that I've grown to prefer over the past several years. It > also prevents me from using Django in our mission-critical apps > because all our tables are segregated into schemas and we use several > tables in different schemas. I don't get the impression that Django is > necessarily targeted at the large, enterprise environment, but I would > prefer to use Django over how we do it now (JBoss and SQL, of > course :). > > Thanks! > > Jon Brisibn > http://jbrisbin.com > > > > > > > -- > http://scott.andstuff.org/ | http://truthadorned.org/ > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---