Thread: Re: New "raw" COPY format

Re: New "raw" COPY format

From
newtglobal postgresql_contributors
Date:
The following review has been posted through the commitfest application:
make installcheck-world:  tested, failed
Implements feature:       tested, failed
Spec compliant:           tested, failed
Documentation:            tested, failed

Hi Joel,
After testing the patch, I observed that for single-column tables, the format evolved from SINGLE to RAW and finally to
LISTto handle diverse data more flexibly. For example, the command: \COPY test.foo2 FROM
'/home/newtdba/postgres-cf-5300/testfiles/testname.txt'WITH (FORMAT LIST); works with CSV, TXT, and RAW files without
specifyingcolumn names. This LIST format is effective for copying data to/from single-column tables but requires
specifyingthe correct format. 

The new status of this patch is: Needs review