Re: data import

Στις Tuesday 21 December 2010 13:36:58 ο/η Pavel Stehule έγραψε:
> Hello
>
> 2010/12/21 Viktor Bojović <viktor(dot)bojovic(at)gmail(dot)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