Postgres Pro
Downloads
Home   >   mailing lists

Re: About COPY command (and probably file fdw too) - Mailing list pgsql-general

From David G. Johnston
Subject Re: About COPY command (and probably file fdw too)
Date
Msg-id CAKFQuwZD=fH7JV6_h39xqLRjdRdh4HZ3nmc97p+mtWCH2abgzw@mail.gmail.com
Whole thread Raw
In response to Re: About COPY command (and probably file fdw too)  (Nicolas Paris <niparisco@gmail.com>)
Responses Re: About COPY command (and probably file fdw too)
List pgsql-general
Tree view
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 by date:

Previous
From: Paul Jungwirth
Date:
Subject: Re: date with month and year
Next
From: "David G. Johnston"
Date:
Subject: Re: date with month and year