Re: inheridt tables from db - Mailing list pgsql-general

From chris smith
Subject Re: inheridt tables from db
Date
Msg-id 3c1395330603250356u29495c0m1b1f587efd025103@mail.gmail.com
Whole thread Raw
In response to inheridt tables from db  (nik600 <nik600@gmail.com>)
List pgsql-general
On 3/25/06, nik600 <nik600@gmail.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/

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: regarding join
Next
From: Peter Eisentraut
Date:
Subject: Re: pgadmin