Assistance with importing a csv into a PostgreSQL database

From: Intengu Technologies <sindile(dot)bidla(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Assistance with importing a csv into a PostgreSQL database
Date: 2009-08-06 08:36:52
Message-ID: a1afa64b0908060136w4cf15542xe2d73dc4b52a3d2e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Dear List,

Please assist me with how to import a csv file into PostgreSQL that
has the following structure - http://pastebin.com/m56bb6cb2.

The challenges are these:
1. import the whole csv into one table - problem is the number of
fields will not be the same for the various rows, the csv has no field
names
2. split this one table into the various tables - a total of 6 tables
3. update the field names with the correct names

--
Sindile Bidla

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Wood 2009-08-06 09:25:23 Re: Assistance with importing a csv into a PostgreSQL database
Previous Message Andreas Wenk 2009-08-06 07:11:21 Re: Graphical user interface