inheridt tables from db
От | nik600 |
---|---|
Тема | inheridt tables from db |
Дата | |
Msg-id | 9469c3170603240914t774bb466h196f15c4697cffa5@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: inheridt tables from db
|
Список | pgsql-general |
hi i am considering to port an important web applications to postgres, this applications is made of php and i reuse the same code for many customer, due to have a clean structure and simple updates... now i have one code and many databases in mysql... i know that with postgres i can inheridt some properties...can i have a main database, called A and then many databases, Customer1, Customer2, Customer3 and if i made a change in A the changes is replicated to Customer1,2 and 3? for example: MAIN DB -> table 1 -> table 2 -> table 3 -- -- CUSTOMER DB 1 -- -- -> table 1 -- -- -> table 2 -- -- -> table 3 -- -- CUSTOMER DB 2 -- -- -> table 1 -- -- -> table 2 -- -- -> table 3 -- -- CUSTOMER DB 3 -- -- -> table 1 -- -- -> table 2 -- -- -> table 3 if i add table4 to MAIN DB automatically i got: MAIN DB -> table 1 -> table 2 -> table 3 -> table 4 -- -- CUSTOMER DB 1 -- -- -> table 1 -- -- -> table 2 -- -- -> table 3 -- -- -> table 4 -- -- CUSTOMER DB 2 -- -- -> table 1 -- -- -> table 2 -- -- -> table 3 -- -- -> table 4 -- -- CUSTOMER DB 3 -- -- -> table 1 -- -- -> table 2 -- -- -> table 3 -- -- -> table 4 if i add a table to CUSTOMER DB 2 it is added ony at db2... is it possible? thanks
В списке pgsql-general по дате отправления: