[postgis-users] Import excel file to postgresql

[Pedro Costa]

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 at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120613/bd3ca761/attachment.html>