import csv file into table

Поиск
Список
Период
Сортировка
От Jude DaShiell
Тема import csv file into table
Дата
Msg-id alpine.NEB.2.11.1506121129310.29044@panix3.panix.com
обсуждение исходный текст
Ответы Re: import csv file into table
Список pgsql-novice
I think this is possible with postgresql using the copy to command.  The
file I have has no blank spaces in it and uses ',' for field separators
and ' for beginning and end of records and has no multi-line records in
it.  Earlier I tried to use the csvfix utility and sql_insert subcommand
to generate insert statements for postgresql.  The record format had so
many errors in it I deleted the file it produced and deleted the utility
from this system.  Has anyone on this list done what I'm about to try?



--



В списке pgsql-novice по дате отправления:

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: Diagnosing poor insert performance in production?
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: import csv file into table