Skip site navigation (1) Skip section navigation (2)

Re: Multiple table insert using a CSV list as the datasource

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Chris Palmer <chris(at)nodewarrior(dot)org>
Cc: Pgsql-Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Multiple table insert using a CSV list as the datasource
Date: 2002-07-14 21:34:38
Message-ID: 20020714213438.GA16175@wolff.to (view raw or flat)
Thread:
Lists: pgsql-novice
On Sun, Jul 14, 2002 at 14:21:10 -0700,
  Chris Palmer <chris(at)nodewarrior(dot)org> wrote:
> On Sunday, July 14, 2002, at 02:10 , Norman Khine wrote:
> 
> >Is there such an SQL statement where you say:
> >
> >Take table csv and put column 1, 2, 3 into table products where column 1
> >should map to products.column1 etc etc ...
> >or take table csv and put column1 and column 4 into table price
> 
> There might be a way to do all that in SQL, but I would do it with a 
> short Perl script using the DBI module. It's fairly straightforward, and 
> the DBI module's documentation is enough to get you going.

If you are talking about after the data has been put into a temporary
table, I don't think this would be a good idea. Doing the copy with
one insert statement is going to be faster.

In response to

Responses

pgsql-novice by date

Next:From: Norman KhineDate: 2002-07-14 21:41:00
Subject: Re: Multiple table insert using a CSV list as the datasource
Previous:From: Bruno Wolff IIIDate: 2002-07-14 21:22:59
Subject: Re: Multiple table insert using a CSV list as the datasource

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group