populate table with large csv file

From: "Dave [Hawk-Systems]" <dave(at)hawk-systems(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: populate table with large csv file
Date: 2003-09-25 16:38:07
Message-ID: DBEIKNMKGOBGNDHAAKGNEEFEFBAC.dave@hawk-systems.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

have the table "numbercheck"
Attribute | Type | Modifier
-----------+------------+----------
svcnumber | integer | not null
svcqual | varchar(9) |
svcequip | char(1) |
svctroub | varchar(6) |
svcrate | varchar(4) |
svcclass | char(1) |
trailer | varchar(3) |
Index: numbercheck_pkey

also have a csv file
7057211380,Y,,,3,B
7057216800,Y,,,3,B
7057265038,Y,,,3,B
7057370261,Y,,,3,B
7057374613,Y,,,3,B
7057371832,Y,,,3,B
4166336554,Y,,,3,B
4166336863,Y,,,3,B
7057201148,Y,,,3,B

aside from parsing the csv file through a PHP interface, what isthe easiest way
to get that csv data importted into the postgres database. thoughts?

thanks

Dave

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joe Conway 2003-09-25 16:43:41 Re: populate table with large csv file
Previous Message Bruce Momjian 2003-09-25 16:33:55 Re: Transactions to localhost

Browse pgsql-performance by date

  From Date Subject
Next Message Joe Conway 2003-09-25 16:43:41 Re: populate table with large csv file
Previous Message Robert Treat 2003-09-25 15:23:12 Re: upping checkpoints on production server