Home > mailing lists

do i need to define a table before importing csv data using copy? - Mailing list pgsql-novice

From	Lille Penguini
Subject	do i need to define a table before importing csv data using copy?
Date	February 14, 2011 22:01:10
Msg-id	AANLkTik1MgZ2m2dTkgN9YbX+SqcKhvuFt_06-ibYXpCO@mail.gmail.com Whole thread Raw
List	pgsql-novice

Tree view

Hi,

I have several csv files each from whose many columns I only require a small subset. How can I avoid the trouble of specifying tables with columns I won't need just to import all this data?

Any suggestions using command line or pgadmin III would be greatly appreciated.

Thanks,

Lille

pgsql-novice by date:

From: Matt
Date: 14 February 2011, 12:25:33
Subject: Re: table design

From: yamt@mwd.biglobe.ne.jp (YAMAMOTO Takashi)
Date: 15 February 2011, 08:41:01
Subject: generate_series

do i need to define a table before importing csv data using copy? - Mailing list pgsql-novice

Previous

Next