Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 2C46D633ED9 for ; Mon, 20 Jul 2009 10:23:03 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 31768-06 for ; Mon, 20 Jul 2009 10:22:44 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from web54306.mail.re2.yahoo.com (web54306.mail.re2.yahoo.com [206.190.49.116]) by mail.postgresql.org (Postfix) with SMTP id 2EA77633BAF for ; Mon, 20 Jul 2009 10:22:51 -0300 (ADT) Received: (qmail 42655 invoked by uid 60001); 20 Jul 2009 13:22:49 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1248096169; bh=/m2+kLHToPNff0DbE+nzkZg41mA90ZPQGvKUmJsx61Q=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=1V0V7FMSrnbwEcXHPTN6be8QzfT4czKFyNDgy1mPq4CFCyy62JX2ukP9FbYfcuhXxCwclgxlezofqTS+9b3wR/AaOoNPYAqmgCDkORJS2DEhCyM5bUFqQWApbr2iLoZAK3AHAj5ySm7cqYOOuLWZegW1p9x/hmIUN0bUxIDVwpo= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=NVqkle3T79TWIhgkgv6pr6f2HPB2tT9UUTSSreeZrDQoSlYL0s21TuVyFKlwEuDX/WHpsUBkdPMn2QaGpcfr+Qc133E1dTOekCJXAJaWfAV/Hw9WUYpwwvJgnlpKPQfrU7zkqpOAw5mp/m4UT3yUUpuf6///Rb1fMYFMUNJyEPA=; Message-ID: <471945.42509.qm@web54306.mail.re2.yahoo.com> X-YMail-OSG: bqIAsMgVM1naGymvemTSPGqmQ0P_00QItwld_KLoIydXSP6VZV8Vhm0.d4j12eg9GqmsU5K.ZSDX_sgKD4nKsg7C7pBDSmk83__2eD.bcCH2Tg1JTIJqAyaqdDlyJiI25FJk8Ka787Hjtnnb_0Ujj.Qs6Kjh9EYTkWyeOC.m3EK1fh9HkNz2tQ8rUIn0jEwbxokGwqxnjNtJKi3hvwYhswF_eaMhY.V.SmuSM9TUDy_7eo6rxyYR3aRg8uNVI0T35kgALR30elHbKcjRDV2GtEKTV_WlWmW3wfJnsEnb9G6nAimvRaIPLUebc4AEycslVQ-- Received: from [68.25.42.245] by web54306.mail.re2.yahoo.com via HTTP; Mon, 20 Jul 2009 06:22:49 PDT X-Mailer: YahooMailClassic/5.4.17 YahooMailWebService/0.7.289.15 Date: Mon, 20 Jul 2009 06:22:49 -0700 (PDT) From: chester c young Subject: unused columns in copy To: sql pgsql MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200907/84 X-Sequence-Number: 32825 is there a way for COPY FROM to ignore unused columns in CSV? in other words, if table t1 has columns c1, c2, and if csv has columns c1, c3, c2, could I do something like COPY t1( c1, null, c2 ) FROM 'file.csv'