Re: Copy from text file

From: Chris <dmagick(at)gmail(dot)com>
To: Ricardo Vaz <jrvaz(at)tce(dot)sp(dot)gov(dot)br>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Copy from text file
Date: 2006-06-23 01:42:43
Message-ID: 449B4713.1080201@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ricardo Vaz wrote:
> Hi,
>
>
> It is possible to copy data from text file (CSV) ignoring some columns
> of this text file?

(How come this was posted 3 times?)

I don't think so but you could load it into a temporary table and then:

insert into new_table select col1, col2 from temp_table;

--
Postgresql & php tutorials
http://www.designmagick.com/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Geoffrey 2006-06-23 01:52:51 Re: Copy from text file
Previous Message Merlin Moncure 2006-06-23 01:33:28 Re: join on next row