I obtened this error: RROR: extra data after last expected column SQL state: 22P04 Context: COPY nueva, line 1: "CODIGO;TIPO;DESCRIPCION;REPRESENTACION;PERFIL;CLAVE;VER3D;CARACBUSQ;LETRA;CAPITULO;SUBCAPITULO;ESTA;..."
2012/6/13 Pedro Costa <pedrocostaa...@sapo.pt> > Hi José, > > You have to convert the excel file to csv and use the copy command like > that: > > > copy table_name from 'C:\Users\TEMP\filename.csv' WITH CSV DELIMITER ';'; > > > You have to create the table before and delete the column names of csv > file. > > > > > Em 13-06-2012 14:46, José María Amuedo escreveu: > > Hi, > > I would like to know how can import excel file to postgresql. I'm working > with linux OS. > > Thanks > > > _______________________________________________ > postgis-users mailing > listpostgis-users@postgis.refractions.nethttp://postgis.refractions.net/mailman/listinfo/postgis-users > > > > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > >
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users