Обсуждение: copy command and column attribute
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?
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
Thanks a lot Guillaume, It worked!! Guillaume Lelarge escribió: > 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. > > >