INSERT or COPY: Which one?

Поиск
Список
Период
Сортировка
Искать
От
Colin Gillespie
Тема
INSERT or COPY: Which one?
Дата
Msg-id
52D580A5DC1FC04CB260E80074CFBA5C02036DC3@bond.ncl.ac.uk
Список
Дерево обсуждения
INSERT or COPY: Which one? "Colin Gillespie" <C.Gillespie@newcastle.ac.uk>
Re: INSERT or COPY: Which one? Nabil Sayegh <postgresql@e-trolley.de>
Re: INSERT or COPY: Which one? Bryan Irvine <bryan.irvine@kingcountyjournal.com>
Re: INSERT or COPY: Which one? Wim <wdh@belbone.be>
Dear All,

I which to insert text (more than 1000 lines) into a single cell of my table, should I use COPY here or INSERT?

My reading seems to suggest that you would use COPY for mulitple INSERTs, but when inserting alot of data into one cell, INSERT is fine. Is this correct?

Thanks

Colin


В списке pgsql-novice по дате отправления
От: Dexter Tad-y
Дата:
От:
Дата:
Сообщение: Re: Createdb fails
FAQ