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 EA537D1D643 for ; Sat, 24 Jan 2004 19:35:52 +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 15378-09 for ; Sat, 24 Jan 2004 15:35:28 -0400 (AST) Received: from fusion.bennyvision.com (fusion.bennyvision.com [216.161.119.28]) by svr1.postgresql.org (Postfix) with SMTP id 1B274D1D561 for ; Sat, 24 Jan 2004 15:35:20 -0400 (AST) Received: (qmail 4116 invoked from network); 24 Jan 2004 19:35:26 -0000 Received: from localhost (HELO webmail.stinkweasel.net) (127.0.0.1) by fusion.bennyvision.com with SMTP; 24 Jan 2004 19:35:26 -0000 Received: from 63.227.74.41 (SquirrelMail authenticated user benny) by webmail.stinkweasel.net with HTTP; Sat, 24 Jan 2004 13:35:04 -0600 (CST) Message-ID: <53076.63.227.74.41.1074972926.squirrel@webmail.stinkweasel.net> Date: Sat, 24 Jan 2004 13:35:04 -0600 (CST) Subject: "mirroring" a table - PostgreSQL 7.3.2 From: "C. Bensend" To: pgsql-admin@postgresql.org User-Agent: SquirrelMail/1.4.2 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 Importance: Normal X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/189 X-Sequence-Number: 12052 Hey folks, I searched the archives and didn't really come up with much, so I'm posting my question here. 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'. The data is irrelevant - any data in 'test_bob' is going to be manipulated, spindled, folded, and mutilated. The data in 'bob' must remain intact. For example, if I ALTER a column or ADD a column to 'bob', I need the exact same thing to happen to 'test_bob'. Is this possible without the typical DROP and CREATE TABLE? Many thanks for any input. :) Benny -- "Have you ever tried simply turning off the TV, sitting down with your children, and hitting them?" -- Bender, "Futurama"