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? -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
