<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"><br>
Try with i sample attached.<br>
<span id="result_box" class="" lang="en"><span class="hps">be sure</span>
<span class="hps">that your</span> <span class="hps">table must</span>
<span class="hps">have columns</span> <span class="hps">according
to the</span> <span class="hps">file</span></span><br>
<br>
<br>
<br>
Em 13-06-2012 15:50, José María Amuedo escreveu:<br>
</div>
<blockquote
cite="mid:CANVkuygb1_cXoNT45yrS44QqgGk4qG9qnROvGYWwBnqxSn1Pcw@mail.gmail.com"
type="cite">this is my file<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>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>
<div>
<div class="h5">
<blockquote 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>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"
target="_blank">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></fieldset>
<br>
<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>
</div>
</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>