populate table with large csv file

Поиск
Список
Период
Сортировка
От Dave [Hawk-Systems]
Тема populate table with large csv file
Дата
Msg-id DBEIKNMKGOBGNDHAAKGNEEFEFBAC.dave@hawk-systems.com
обсуждение исходный текст
Ответы Re: populate table with large csv file  (Joe Conway <mail@joeconway.com>)
Re: populate table with large csv file  ("P.J. \"Josh\" Rovero" <rovero@sonalysts.com>)
Re: populate table with large csv file  (Ron Johnson <ron.l.johnson@cox.net>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Transactions to localhost
Следующее
От: Joe Conway
Дата:
Сообщение: Re: populate table with large csv file