Assuming I have a schema with the name "my_schema", how can I create tables with "django syncdb" for that particular schema? Or is there any other alternatives for quickly creating tables from my django models? I think, by default django creates tables for the "public" schema.
5
-
Are you talking about option --database=DATABASE: Nominates a database to synchronize. Defaults to the "default" database.jpic– jpic2011-12-30 15:00:15 +00:00Commented Dec 30, 2011 at 15:00
-
No. I am referring to schema. postgresql.org/docs/9.0/static/ddl-schemas.html .By default django uses the schema named "public"Devasia Joseph– Devasia Joseph2011-12-30 16:54:09 +00:00Commented Dec 30, 2011 at 16:54
-
1Django does not use 'public' schema by default. Psycopg2 uses 'public' schema by default (yes i've read the code with grep). You can try to set 'OPTIONS': { 'schema': 'yourschema' } in your DATABASE definition (at the same level than 'USER', 'HOST', etc ...).jpic– jpic2011-12-30 17:04:12 +00:00Commented Dec 30, 2011 at 17:04
-
3According to the source code of psycopg 2.4.1, extras.py line 863: you should prefix your database NAME setting with the schema name and a dot.jpic– jpic2011-12-30 17:12:55 +00:00Commented Dec 30, 2011 at 17:12
-
jpic: that code in extras.py is only invoked when registering a typecaster for automatically converting composite types, it has nothing to do with setting a default schema name, so far, I have been unable to find a way to do.John– John2012-08-28 00:11:19 +00:00Commented Aug 28, 2012 at 0:11
Add a comment
|
2 Answers
First, you must have psycopg2>=2.4.3 [1]. If you have then you can add schema to OPTIONS in dictionary-based database configuration, like this:
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.postgresql_psycopg2',
# ...
'OPTIONS': {
'options': '-c search_path=my_schema'
}
}
}
Tested on postgresql 8.4 and django 1.3
Comments
I have used following info and work for me
'default': { 'ENGINE': 'django.db.backends.postgresql_psycopg2', 'NAME': 'dab_name', 'USER': 'username', 'PASSWORD': 'password', 'HOST': 'localhost', 'PORT': '5432', 'OPTIONS': { 'options': '-c search_path=tours' #schema name } }
Tested on postgresql 9 and django 1.10.2
Thanks @romke
