From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Organization: Dynacom Tankers Mgmt
To: pgsql-sql@postgresql.org
Subject: Re: data import
Date: Tue, 21 Dec 2010 15:04:48 +0300
User-Agent: KMail/1.9.7
References: <AANLkTim1XmvAYSJJqXVbDAidh2X1N6W4PCBsTS+ybw2F@mail.gmail.com>
	<AANLkTin6o+jTe74toH+JQ2T4uKheGYswY2Ja-+RpeDOf@mail.gmail.com>
In-Reply-To: <AANLkTin6o+jTe74toH+JQ2T4uKheGYswY2Ja-+RpeDOf@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <201012211404.48311.achill@matrix.gatewaynet.com>

=CE=A3=CF=84=CE=B9=CF=82 Tuesday 21 December 2010 13:36:58 =CE=BF/=CE=B7 Pa=
vel Stehule =CE=AD=CE=B3=CF=81=CE=B1=CF=88=CE=B5:
> Hello
>=20
> 2010/12/21 Viktor Bojovi=C4=87 <viktor.bojovic@gmail.com>:
> > Hi,
> >
> > can anyone recommend me a windows and linux free tools for importing da=
ta
> > into postgre.
> > Source files are CSV or excel.
>=20

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 whee=
l again.
The way to do it, IIRC, is to "create" a database based on your existing ex=
cel data source.
After that you can copy data from this "excel-powered" database to your nor=
mal 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
>=20
> Regards
>=20
> Pavel Stehule
>=20
> > Thanx in advance
> > --
> > ---------------------------------------
> > Viktor Bojovi=C4=87
> > ---------------------------------------
> > Wherever I go, Murphy goes with me
> >
>=20


=2D-=20
Achilleas Mantzios