Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 24079633771 for ; Mon, 30 Mar 2009 12:13:00 -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 20337-08 for ; Mon, 30 Mar 2009 12:12:58 -0300 (ADT) X-Greylist: delayed 00:32:33.73801 by SQLgrey-1.7.6 Received: from imeil2.udg.edu (mailout10.udg.edu [84.88.128.10]) by mail.postgresql.org (Postfix) with ESMTP id 1DA7763355A for ; Mon, 30 Mar 2009 12:12:57 -0300 (ADT) Received: from sigte (besalu.udg.edu [84.88.143.241]) by imeil2.udg.edu (8.13.8/8.11.1/otb) with ESMTP id n2UEeJrw028138 for ; Mon, 30 Mar 2009 16:40:19 +0200 Received: from [84.88.143.14] (sig6.udg.edu [84.88.143.14]) by sigte (Postfix) with ESMTP id 277A86373B for ; Mon, 30 Mar 2009 16:32:36 +0200 (CEST) Message-ID: <49D0D9BF.20407@sigte.udg.edu> Date: Mon, 30 Mar 2009 16:39:59 +0200 From: =?ISO-8859-1?Q?toni_hern=E1ndez?= User-Agent: Thunderbird 2.0.0.21 (Windows/20090302) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: copy command and column attribute Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200903/249 X-Sequence-Number: 31749 hi all, I've been trying to import some data from a csv file to my database. I have some fields of the table that I want to keep so I typed copy mytable (column Affidabilita_stratigrafica,Ambiente,Anno,Componenti_geologici) FROM E'c://export_us_sg4.csv' with delimiter ',' csv quote as '"'; This way I expect some fields to remain with the default value, but an error appears near "column" Am I typing it wrong?