Στις Tuesday 21 December 2010 13:36:58 ο/η Pavel Stehule έγραψε: > Hello > > 2010/12/21 Viktor Bojović <viktor.bojo...@gmail.com>: > > Hi, > > > > can anyone recommend me a windows and linux free tools for importing data > > into postgre. > > Source files are CSV or excel. >
Openoffice can do this job, populating a table from an excel data source, but every time i do it (which is not often) it is like reinventing the wheel again. The way to do it, IIRC, is to "create" a database based on your existing excel data source. After that you can copy data from this "excel-powered" database to your normal pgsql database, fairly easily. It is easy actually, just not so straight forward as most people would want. > PostgreSQL can read a CVS files via a COPY statement. You can use a > \copy metacommand too from psql > > Regards > > Pavel Stehule > > > Thanx in advance > > -- > > --------------------------------------- > > Viktor Bojović > > --------------------------------------- > > Wherever I go, Murphy goes with me > > > -- Achilleas Mantzios -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
