Обсуждение: data import

Hello

2010/12/21 Viktor Bojović <viktor.bojovic@gmail.com>:
> Hi,
>
> can anyone recommend me a windows and linux free tools for importing data
> into postgre.
> Source files are CSV or excel.

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
>

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

If your file is TAB delimited, you can simply do:

\copy tablename from 'some file'

To get details in psql, do:
psql mydatabase
and at the prompt:
\h copy



On Dec 21, 2010, at 06:34 , Viktor Bojović wrote:

> Hi,
>
> can anyone recommend me a windows and linux free tools for importing data into postgre.
> Source files are CSV or excel.
>
> Thanx in advance
> --
> ---------------------------------------
> Viktor Bojović
> ---------------------------------------
> Wherever I go, Murphy goes with me