Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 0E8641337B6C
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 28 Dec 2010 22:00:06 -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 74037-04-6 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed, 29 Dec 2010 01:59:55 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-vw0-f46.google.com (mail-vw0-f46.google.com
	[209.85.212.46])
	by mail.postgresql.org (Postfix) with ESMTP id EC01D1337C5C
	for <pgsql-sql@postgresql.org>; Tue, 28 Dec 2010 21:45:03 -0400 (AST)
Received: by vws16 with SMTP id 16so4001423vws.19
	for <pgsql-sql@postgresql.org>; Tue, 28 Dec 2010 17:45:04 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:received:in-reply-to
	:references:date:message-id:subject:from:to:cc:content-type;
	bh=sVjxfggfKGdhuQcp0QD+s3jjEVA6/cryRmfeR3qYYjc=;
	b=F888KgRS5ILF92IO+F39UF5pu82RaYNMsrUKvpr/nAXBtAfvni8y107vXMQhsdDmB6
	JHxH1Op5bluDtaid6qhBKKZqWr8ESJpWgCMcJjsnKNUrxD/+5nO5WiKXeKEWSBmW6rgj
	dPqRDyLPcmuFuEsn+E7NkkVtSHAXL7id0IECA=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=tzq4xUcdJ5TWM9WmV2ziiezztTFlCplewMdMOcsUOts0l32Gr2mZGMC7/pQycVf5W0
	qC9RAYLgpX9wWFZ3YPnSSCxJ9egadC4V4mUoLsy4OjJoNSnF6QIDGsoyIWX6VEaFul0K
	nzjOV66UICKH+xzfpDAt9XIfAXjci9xIXa7IY=
MIME-Version: 1.0
Received: by 10.220.181.77 with SMTP id bx13mr305304vcb.214.1293587102512;
	Tue, 28 Dec 2010 17:45:02 -0800 (PST)
Received: by 10.220.201.68 with HTTP; Tue, 28 Dec 2010 17:45:02 -0800 (PST)
In-Reply-To: <E9ABF592-83E2-4FAE-A004-936CAA49470B@ruprecht.org>
References: <AANLkTim1XmvAYSJJqXVbDAidh2X1N6W4PCBsTS+ybw2F@mail.gmail.com>
	<E9ABF592-83E2-4FAE-A004-936CAA49470B@ruprecht.org>
Date: Wed, 29 Dec 2010 02:45:02 +0100
Message-ID: <AANLkTimOCVeXiPtvL+PhbCXrS1D2=H9EdYVtGCTr_AVK@mail.gmail.com>
Subject: Re: data import
From: =?UTF-8?Q?Viktor_Bojovi=C4=87?= <viktor.bojovic@gmail.com>
To: Chris Ruprecht <chris@ruprecht.org>
Cc: pgsql-sql@postgresql.org
Content-Type: multipart/alternative; boundary=90e6ba53ad50bb38d3049882b75b
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.597 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_LOW=-0.7,
	RFC_ABUSE_POST=0.001
X-Spam-Level: 
X-Archive-Number: 201012/102
X-Sequence-Number: 34938

--90e6ba53ad50bb38d3049882b75b
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Thanx Chris.
Also i want to thank Achilleas and Pavel for help

On Tue, Dec 21, 2010 at 5:18 PM, Chris Ruprecht <chris@ruprecht.org> wrote:

> 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,
> >
> > can anyone recommend me a windows and linux free tools for importing da=
ta
> into postgre.
> > Source files are CSV or excel.
> >
> > Thanx in advance
> > --
> > ---------------------------------------
> > Viktor Bojovi=C4=87
> > ---------------------------------------
> > Wherever I go, Murphy goes with me
>
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>



--=20
---------------------------------------
Viktor Bojovi=C4=87
---------------------------------------
Wherever I go, Murphy goes with me

--90e6ba53ad50bb38d3049882b75b
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div>Thanx Chris.<br></div><div>Also i want to thank Achilleas and Pavel fo=
r help</div><br><div class=3D"gmail_quote">On Tue, Dec 21, 2010 at 5:18 PM,=
 Chris Ruprecht <span dir=3D"ltr">&lt;<a href=3D"mailto:chris@ruprecht.org"=
>chris@ruprecht.org</a>&gt;</span> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex;">If your file is TAB delimited, you can simp=
ly do:<br>
<br>
\copy tablename from &#39;some file&#39;<br>
<br>
To get details in psql, do:<br>
psql mydatabase<br>
and at the prompt:<br>
\h copy<br>
<div><div class=3D"h5"><br>
<br>
<br>
On Dec 21, 2010, at 06:34 , Viktor Bojovi=C4=87 wrote:<br>
<br>
&gt; Hi,<br>
&gt;<br>
&gt; can anyone recommend me a windows and linux free tools for importing d=
ata into postgre.<br>
&gt; Source files are CSV or excel.<br>
&gt;<br>
&gt; Thanx in advance<br>
&gt; --<br>
&gt; ---------------------------------------<br>
&gt; Viktor Bojovi=C4=87<br>
&gt; ---------------------------------------<br>
&gt; Wherever I go, Murphy goes with me<br>
<br>
<br>
</div></div><div><div class=3D"h5">--<br>
Sent via pgsql-sql mailing list (<a href=3D"mailto:pgsql-sql@postgresql.org=
">pgsql-sql@postgresql.org</a>)<br>
To make changes to your subscription:<br>
<a href=3D"http://www.postgresql.org/mailpref/pgsql-sql" target=3D"_blank">=
http://www.postgresql.org/mailpref/pgsql-sql</a><br>
</div></div></blockquote></div><br><br clear=3D"all"><br>-- <br>-----------=
----------------------------<br>Viktor Bojovi=C4=87<br>--------------------=
-------------------<br>Wherever I go, Murphy goes with me<br>

--90e6ba53ad50bb38d3049882b75b--