Displaying 1 result from an estimated 1 matches for "megaproject_db".
2005 Oct 28
3
PostgreSQL. Multiply schemas in one database. How to?
...that are belongs to public schema. This info makes sql file huge
(1500 lines) - I dont like such files with a lot of unnecessary information.
And probably it would break if different devs working on different versions
of db.
So I decided to make following structure that seems much prettier for me
megaproject_db
- public schema (db info)
- test schema
- development schema
- production schema
Does anybody tried to make the same thing that I want to do?
I found in wiki that I need to add schema_search_path to db config file.
So first question: why so strange name for schema property?? I have looked
through...