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
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 |
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 |