"C. Bensend" <benny(at)bennyvision(dot)com> writes:
> I have two tables in the same database, whose structure I want to be
> identical. Call them 'bob' and 'test_bob' for example.
> If I make a change to the schema of 'bob', I want that exact change to
> happen to 'test_bob'.
Possibly you could get the effect you want by making one a child of the
other. Read up on inheritance. There are some side-effects you'd
probably *not* want, so this isn't a perfect solution, but I can't think
of anything else.
regards, tom lane
In response to
pgsql-admin by date
|Next:||From: C. Bensend||Date: 2004-01-24 21:21:38|
|Subject: Re: "mirroring" a table - PostgreSQL 7.3.2|
|Previous:||From: Bruno Wolff III||Date: 2004-01-24 20:22:20|
|Subject: Re: Easy pg_hba.conf question.|