Re: Copy from text file - Mailing list pgsql-general

From Chris
Subject Re: Copy from text file
Date
Msg-id 449B4713.1080201@gmail.com
Whole thread Raw
In response to Copy from text file  ("Ricardo Vaz" <jrvaz@tce.sp.gov.br>)
Responses Re: Copy from text file
List 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/

pgsql-general by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: join on next row
Next
From: Geoffrey
Date:
Subject: Re: Copy from text file