Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 9853B476AA5 for ; Wed, 13 Nov 2002 23:44:47 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 82E27476A9F for ; Wed, 13 Nov 2002 23:44:46 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.5/8.12.5) with ESMTP id gAE4iohR027289; Wed, 13 Nov 2002 23:44:50 -0500 (EST) To: Tim Perdue , pgsql-sql@postgresql.org Subject: Re: Old "Feature" - Copy table ignores column defaults In-reply-to: <27212.1037248669@sss.pgh.pa.us> References: <3DD2FF93.6060706@perdue.net> <27212.1037248669@sss.pgh.pa.us> Comments: In-reply-to Tom Lane message dated "Wed, 13 Nov 2002 23:37:49 -0500" Date: Wed, 13 Nov 2002 23:44:50 -0500 Message-ID: <27288.1037249090@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/219 X-Sequence-Number: 10361 I said: > 7.3 does have the ability to COPY a subset of a column's tables and > insert default values for the omitted columns. s/column's tables/table's columns/ Must be time to go to bed ... regards, tom lane