<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Send me a sample of your file. But you
have to remove the last semicolon.<br>
<br>
Your file have to be like that:<br>
<br>
<br>
column1;column2;column3;333333.3333<br>
column1_r2;column2_r2;column3_r2;333333.3333<br>
<br>
<br>
<br>
<br>
Em 13-06-2012 15:34, José María Amuedo escreveu:<br>
</div>
<blockquote
cite="mid:CANVkuygfgDQyVbmw2GjqnCv6Y+M1iijtiHVc5Ox-VStTS1YBSg@mail.gmail.com"
type="cite">I obtened this error:<br>
<br>
RROR: extra data after last expected column<br>
SQL state: 22P04<br>
Context: COPY nueva, line 1:
"CODIGO;TIPO;DESCRIPCION;REPRESENTACION;PERFIL;CLAVE;VER3D;CARACBUSQ;LETRA;CAPITULO;SUBCAPITULO;ESTA;..."<br>
<br>
<div class="gmail_quote">2012/6/13 Pedro Costa <span dir="ltr"><<a
moz-do-not-send="true" href="mailto:pedrocostaarma@sapo.pt"
target="_blank">pedrocostaarma@sapo.pt</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div>Hi José,<br>
<br>
You have to convert the excel file to csv and use the copy
command like that:<br>
<br>
<br>
copy table_name from 'C:\Users\TEMP\filename.csv' WITH CSV
DELIMITER ';';<br>
<br>
<br>
You have to create the table before and delete the column
names of csv file.<br>
<br>
<br>
<br>
<br>
Em 13-06-2012 14:46, José María Amuedo escreveu:<br>
</div>
<blockquote type="cite">
<div class="im">Hi,<br>
<br>
I would like to know how can import excel file to
postgresql. I'm working with linux OS.<br>
<br>
Thanks<br>
<br>
<fieldset></fieldset>
<br>
</div>
<pre>_______________________________________________
postgis-users mailing list
<a moz-do-not-send="true" href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a>
<a moz-do-not-send="true" href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
<br>
<br>
</div>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a moz-do-not-send="true"
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br>
</blockquote>
</div>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
<br>
<br>
</body>
</html>