Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 36F461337B79
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 21 Dec 2010 12:23:58 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 20127-01 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 21 Dec 2010 16:23:51 +0000 (UTC)
X-Greylist: delayed 00:05:45.427172 by SQLgrey-1.7.6
Received: from mail-yw0-f46.google.com (mail-yw0-f46.google.com
	[209.85.213.46])
	by mail.postgresql.org (Postfix) with ESMTP id 0246A1337B9A
	for <pgsql-sql@postgresql.org>; Tue, 21 Dec 2010 12:23:50 -0400 (AST)
Received: by ywl5 with SMTP id 5so1830419ywl.19
	for <pgsql-sql@postgresql.org>; Tue, 21 Dec 2010 08:23:50 -0800 (PST)
Received: by 10.100.178.17 with SMTP id a17mr3381294anf.98.1292948284602;
	Tue, 21 Dec 2010 08:18:04 -0800 (PST)
Received: from [192.168.0.11] (75-139-158-182.dhcp.gwnt.ga.charter.com
	[75.139.158.182])
	by mx.google.com with ESMTPS id e24sm9882641ana.22.2010.12.21.08.18.01
	(version=TLSv1/SSLv3 cipher=RC4-MD5);
	Tue, 21 Dec 2010 08:18:01 -0800 (PST)
Content-Type: text/plain; charset=utf-8
Mime-Version: 1.0 (Apple Message framework v1082)
Subject: Re: data import
From: Chris Ruprecht <chris@ruprecht.org>
In-Reply-To: <AANLkTim1XmvAYSJJqXVbDAidh2X1N6W4PCBsTS+ybw2F@mail.gmail.com>
Date: Tue, 21 Dec 2010 11:18:00 -0500
Content-Transfer-Encoding: quoted-printable
Message-Id: <E9ABF592-83E2-4FAE-A004-936CAA49470B@ruprecht.org>
References: <AANLkTim1XmvAYSJJqXVbDAidh2X1N6W4PCBsTS+ybw2F@mail.gmail.com>
To: pgsql-sql@postgresql.org
X-Mailer: Apple Mail (2.1082)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.6 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	RCVD_IN_DNSWL_LOW=-0.7
X-Spam-Level: 
X-Archive-Number: 201012/98
X-Sequence-Number: 34934

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=C4=87 wrote:

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