do i need to define a table before importing csv data using copy?

From: Lille Penguini <lille(dot)penguini(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: do i need to define a table before importing csv data using copy?
Date: 2011-02-14 22:58:51
Message-ID: AANLkTik1MgZ2m2dTkgN9YbX+SqcKhvuFt_06-ibYXpCO@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Browse pgsql-novice by date

  From Date Subject
Next Message YAMAMOTO Takashi 2011-02-15 02:06:46 generate_series
Previous Message Matt 2011-02-14 13:25:23 Re: table design