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
Re: populate table with large csv file Re: populate table with large csv file |
Список | 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 по дате отправления: