Re: data import - Mailing list pgsql-sql

From Chris Ruprecht
Subject Re: data import
Date
Msg-id E9ABF592-83E2-4FAE-A004-936CAA49470B@ruprecht.org
Whole thread Raw
In response to data import  (Viktor Bojović <viktor.bojovic@gmail.com>)
Responses Re: data import
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: data import
Next
From: Basil Bourque
Date:
Subject: Re: linux. ossp-uuid