Postgres Schema

Hi All, This topic has been discussed before. But Have not found a solution . I want to add a schema search path to my connection object at the time of creating the django connection object for Postgres. I know that in models.py I can set the db_table = '"schema"."table_name"' . This works fine

bottom line on postgres schema use in 0.96?

hi. i have been working to make use of postres schema in an app wit version 0.96. tried 3 options: 1. in settings.py, put in an entry like this: CONNECTION_INIT_SQL = ( 'SET search_path TO django_application_schema',) 2. in settings.py, put in an entry like this: DATABASE_SCHEMAS = 'django_appli

Re: postgres schema support

Hello, I think there are a few open-tickets for this topic: http://code.djangoproject.com/ticket/1051 http://code.djangoproject.com/ticket/6148 http://code.djangoproject.com/ticket/2120 Bernd On Jul 11, 3:50 pm, Jon Brisbin <[EMAIL PROTECTED]> wrote: > I hardly ever put anything in the Postgre

Re: postgres schema support

Aah, I think you'll need to create the schema yourself. -- Scott On Fri, Jul 11, 2008 at 10:35 AM, Jon Brisbin <[EMAIL PROTECTED]> wrote: > 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 > mysel

Re: postgres schema support

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

Re: postgres schema support

Hi Jon. I believe you can use the Django model meta property db_table to specify the schema. According to ticket #6064you need to use somewhat hackneyed syntax at the moment (notice the outer single quotes and the explicit inner double quotes): class My

postgres schema support

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 prett