copy command and column attribute - Mailing list pgsql-admin

From toni hernández
Subject copy command and column attribute
Date
Msg-id 49D0D9BF.20407@sigte.udg.edu
Whole thread Raw
Responses Re: copy command and column attribute
List pgsql-admin
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?


pgsql-admin by date:

Previous
From: Harald Fuchs
Date:
Subject: Re: Partitionin with check functions
Next
From: Guillaume Lelarge
Date:
Subject: Re: copy command and column attribute