X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 98DCFD1E992 for ; Sat, 24 Jan 2004 21:10:25 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 35185-05 for ; Sat, 24 Jan 2004 17:10:01 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 76C61D1E980 for ; Sat, 24 Jan 2004 17:09:53 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.10/8.12.10) with ESMTP id i0OL9xnX005234; Sat, 24 Jan 2004 16:09:59 -0500 (EST) To: "C. Bensend" Cc: pgsql-admin@postgresql.org Subject: Re: "mirroring" a table - PostgreSQL 7.3.2 In-reply-to: <53076.63.227.74.41.1074972926.squirrel@webmail.stinkweasel.net> References: <53076.63.227.74.41.1074972926.squirrel@webmail.stinkweasel.net> Comments: In-reply-to "C. Bensend" message dated "Sat, 24 Jan 2004 13:35:04 -0600" Date: Sat, 24 Jan 2004 16:09:59 -0500 Message-ID: <5233.1074978599@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/191 X-Sequence-Number: 12054 "C. Bensend" 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