Send me a sample of your file. But you have to remove the last semicolon.
Your file have to be like that:
column1;column2;column3;333333.3333
column1_r2;column2_r2;column3_r2;333333.3333
Em 13-06-2012 15:34, José María Amuedo escreveu:
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
<mailto: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 list
postgis-users@postgis.refractions.net
<mailto:postgis-users@postgis.refractions.net>
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
<mailto: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
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users