Le lundi 30 mars 2009 à 16:39:59, toni hernández a écrit : > [...] > 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? Yes, there should be no COLUMN keyword in this statement. copy mytable (Affidabilita_stratigrafica,Ambiente,Anno,Componenti_geologici) FROM E'c://export_us_sg4.csv' with delimiter ',' csv quote as '"'; This should work better. -- Guillaume. http://www.postgresqlfr.org http://dalibo.com -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
