Re: Multiple table insert using a CSV list as the datasource - Mailing list pgsql-novice

On Sun, Jul 14, 2002 at 22:10:36 +0100,
  Norman Khine <norman@khine.net> 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 ...

insert into products (column1, column2, column3) select * from csv;

> or take table csv and put column1 and column 4 into table price

insert into price select column1, column4 from csv;