Re: Problem with COPY - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Problem with COPY
Date
Msg-id 20060711132207.GA3680@surnet.cl
Whole thread Raw
In response to Re: Problem with COPY  ("Leif B. Kristensen" <leif@solumslekt.org>)
Responses Re: Problem with COPY
List pgsql-general
Leif B. Kristensen wrote:
> On Tuesday 11. July 2006 10:10, A. Kretschmer wrote:
> >Do you have a UNIX-like operating system? Then you can use tools like
> >'cut':
> >
> >kretschmer@tux:~$ echo "s1,s2,s3" | cut -d ',' -f 1,3
> >s1,s3
> >
> >This result can you pipe into psql.
>
> It would be nice, though, if we had something like Oracle's SQL-Loader
> for PostgreSQL. It's a very powerful tool for transforming and loading
> data.

We do have very powerful tools, even more powerful than SQL-Loader.
They require a bit more work to use though.  Perl, for example.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-general by date:

Previous
From: zordax
Date:
Subject: Passwords problems
Next
From: "Leif B. Kristensen"
Date:
Subject: Re: Problem with COPY