Re: [ADMIN] copy command and column attribute

2009-03-31 Thread toni hernández
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 Affidab

Re: [ADMIN] copy command and column attribute

2009-03-30 Thread Guillaume Lelarge
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 >

[ADMIN] copy command and column attribute

2009-03-30 Thread toni hernández
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 '"'; T