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 4808DD1E9D1 for ; Sat, 24 Jan 2004 21:22:27 +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 40260-01 for ; Sat, 24 Jan 2004 17:22:02 -0400 (AST) Received: from fusion.bennyvision.com (fusion.bennyvision.com [216.161.119.28]) by svr1.postgresql.org (Postfix) with SMTP id 9897FD1E3EB for ; Sat, 24 Jan 2004 17:21:53 -0400 (AST) Received: (qmail 22778 invoked from network); 24 Jan 2004 21:22:00 -0000 Received: from localhost (HELO webmail.stinkweasel.net) (127.0.0.1) by fusion.bennyvision.com with SMTP; 24 Jan 2004 21:22:00 -0000 Received: from 63.227.74.41 (SquirrelMail authenticated user benny) by webmail.stinkweasel.net with HTTP; Sat, 24 Jan 2004 15:21:38 -0600 (CST) Message-ID: <56251.63.227.74.41.1074979320.squirrel@webmail.stinkweasel.net> In-Reply-To: <5233.1074978599@sss.pgh.pa.us> References: <53076.63.227.74.41.1074972926.squirrel@webmail.stinkweasel.net> <5233.1074978599@sss.pgh.pa.us> Date: Sat, 24 Jan 2004 15:21:38 -0600 (CST) Subject: Re: "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/192 X-Sequence-Number: 12055 > 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. Thanks for the quick reply, Tom. I appreciate that. I've looked at this, and it seems to be on the same level as a quick DROP/CREATE. Is there no way to "mirror" a table structure in real time? CREATE TABLE test_bob AS ( SELECT * FROM bob WHERE '1' = '2' ); .. appears to also do what I want, but I'd like to be able to do this without DROP/CREATE (just because I'm anal, no other real reason). :) Thoughts? Benny -- "Have you ever tried simply turning off the TV, sitting down with your children, and hitting them?" -- Bender, "Futurama"