Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 53CD69FA5DD for ; Thu, 8 Feb 2007 03:16:42 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 18054-07 for ; Thu, 8 Feb 2007 03:16:15 -0400 (AST) X-Greylist: delayed 08:54:46.115647 by SQLgrey-1.7.4 Received: from outX.internet-mail-service.net (outX.internet-mail-service.net [216.240.47.247]) by postgresql.org (Postfix) with ESMTP id 9AD3F9FA36A for ; Thu, 8 Feb 2007 03:16:15 -0400 (AST) Received: from mx0.idiom.com (HELO idiom.com) (216.240.32.160) by out.internet-mail-service.net (qpsmtpd/0.32) with ESMTP; Wed, 07 Feb 2007 22:53:42 -0800 Received: from [192.168.1.109] (adsl-71-135-160-185.dsl.pltn13.pacbell.net [71.135.160.185]) by idiom.com (Postfix) with ESMTP id 2398D125B23; Wed, 7 Feb 2007 23:16:13 -0800 (PST) Message-ID: <45CACE3C.4010302@obviously.com> Date: Wed, 07 Feb 2007 23:16:12 -0800 From: Bryce Nesbitt User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1) Gecko/20061107 SUSE/1.0.99-18 SeaMonkey/1.1b MIME-Version: 1.0 To: pgsql-sql@postgresql.org CC: "Hiltibidal, Robert" Subject: Re: Seeking quick way to clone a row, but give it a new pk. References: In-Reply-To: Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.158 tagged_above=0 required=5 tests=AWL, BAYES_50 X-Spam-Level: X-Archive-Number: 200702/74 X-Sequence-Number: 27408 I have a table that describes some properties. It is logically equivalent to: pk userid favorite_color time_zone count 122 100 red Pacific 7 145 101 blue Eastern 7 For various reasons I need to manually add a few rows to this table. Manually copying one users row, then editing it, would be easier than starting from scratch. Hiltibidal, Robert wrote: > What are you trying to accomplish? > > The more normalized a database is the faster it operates, the more > efficient it will be. What you are describing creates a lot of in > efficiencies within a database. >