populate table with large csv file - Mailing list pgsql-general

From Dave [Hawk-Systems]
Subject populate table with large csv file
Date
Msg-id DBEIKNMKGOBGNDHAAKGNEEFEFBAC.dave@hawk-systems.com
Whole thread Raw
Responses Re: populate table with large csv file
Re: populate table with large csv file
Re: populate table with large csv file
List pgsql-general
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



pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Transactions to localhost
Next
From: Joe Conway
Date:
Subject: Re: populate table with large csv file