Re: inheridt tables from db

On 3/25/06, nik600 <nik600(at)gmail(dot)com> wrote:
> 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?

Databases don't have inherited properties, but tables do.

http://www.postgresql.org/docs/8.1/static/tutorial-inheritance.html

http://www.postgresql.org/docs/8.1/static/ddl-inherit.html

--
Postgresql & php tutorials
http://www.designmagick.com/