Re: About COPY command (and probably file fdw too)

Поиск
Список
Период
Сортировка
От Stefan Stefanov
Тема Re: About COPY command (and probably file fdw too)
Дата
Msg-id 2F57AD5B447948489394E3587394600B@mbmbg.net
обсуждение исходный текст
Ответ на Re: About COPY command (and probably file fdw too)  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general
Дерево обсуждения
Hi,
I agree, pgloader seems to be right. And yes, it’s a matter of complexity and usability estimation.
Stefan
 
Sent: Friday, May 22, 2015 12:19 AM
Subject: Re: [GENERAL] About COPY command (and probably file fdw too)
 
On Thu, May 21, 2015 at 1:33 PM, Nicolas Paris <niparisco@gmail.com> wrote:
Hi,
 
To me this would be great. Why not the ability to restrict lines too
COPY stafflist (userid, username, staffid)
FROM 'myfile.txt'
WITH (FORMAT text, DELIMITER E'\t', COLUMNS (1, 2, 7), LINES(2:1000,2000:3000), ENCODING 'windows-1250')
=> subset of full data.
 
 
​At some level of complexity it is questionable whether a feature belongs in core that can exist outside of it.
 
While I have not yet personally used pgloader it seems to accomplish much of what is being requested.
 
 
COPY (and \copy) serves its purpose extremely well​
 
​but expects the user to deal with any customization needed either before or after it has done its thing.  I believe this is for the best since such customizations and tools have no need to operate on the same release cycle as the core PostgreSQL project.
 
David J.
​

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: FW: Constraint exclusion in partitions
Следующее
От: "Stefan Stefanov"
Дата:
Сообщение: Re: About COPY command (and probably file fdw too)