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
