From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
To: pgsql-sql@postgresql.org
Subject: Re: data import
Date: Tue, 21 Dec 2010 15:04:48 +0300
Message-ID: <201012211404.48311.achill@matrix.gatewaynet.com> (raw)
In-Reply-To: <AANLkTin6o+jTe74toH+JQ2T4uKheGYswY2Ja-+RpeDOf@mail.gmail.com>
References: <AANLkTim1XmvAYSJJqXVbDAidh2X1N6W4PCBsTS+ybw2F@mail.gmail.com>
<AANLkTin6o+jTe74toH+JQ2T4uKheGYswY2Ja-+RpeDOf@mail.gmail.com>
Στις 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: achill@matrix.gatewaynet.com
Subject: Re: data import
In-Reply-To: <201012211404.48311.achill@matrix.gatewaynet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox