Skip site navigation (1) Skip section navigation (2)

Re: "mirroring" a table - PostgreSQL 7.3.2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "C(dot) Bensend" <benny(at)bennyvision(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: "mirroring" a table - PostgreSQL 7.3.2
Date: 2004-01-24 21:09:59
Message-ID: 5233.1074978599@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
"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

Responses

pgsql-admin by date

Next:From: C. BensendDate: 2004-01-24 21:21:38
Subject: Re: "mirroring" a table - PostgreSQL 7.3.2
Previous:From: Bruno Wolff IIIDate: 2004-01-24 20:22:20
Subject: Re: Easy pg_hba.conf question.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group